SQL examples for SQL Server
The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Jira.
- Create a comment (formatted body)
- Create a comment (plain text body)
- Create a project
- Create a user
- Create a worklog
- Create an issue
- Create multiple issues (bulk from external source)
- Delete a project
- Delete a user
- Delete a worklog
- Delete an existing comment
- Delete an issue
- Delete multiple issues by JQL
- Read an issue by ID
- Read an issue by ID — continue on specific error
- Read an issue by Key
- Read comments for all issues
- Read comments for an issue by ID or Key
- Read comments for an issue by Key
- Read comments for issues by JQL
- Read custom fields with nested structures (SLA fields)
- Read fields
- Read issues
- Read issues (specific fields only)
- Read issues for a project
- Read issues using JQL query
- Read issues with all columns (including SLA / nested custom fields)
- Read multiple issues by ID or Key
- Read projects
- Read users
- Read worklog entries for an issue by ID or Key
- Read worklogs
- Read worklogs for issues by JQL
- Read worklogs modified after a date
- Update a project
- Update a worklog
- Update an existing comment (plain text body)
- Update an issue
- Update custom multi-select, user, or team fields (raw JSON)
- Update custom option field (dropdown or radio)
- Update multiple issues by JQL
- Update or create an issue with custom fields