...
This query above will show the fields of the issue with id = 10000.
ID | KEY | ASSIGNEE | CREATED | DESCRIPTION | DUE | ENVIRONMENT | ORIGINALESTIMATE | PARENTID | PRIORITYID | PROGRESS | PROJECTID | REMAININGESTIMATE | REPORTER | RESOLUTIONID | RESOLVED | SECURITYLEVEL | STATUSID | SUMMARY | TYPEID | TIMESPENT | UPDATED | VOTES | WATCHES | WORKRATIO | ISARCHIVED | JQL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10000 | DEMO-1 | admin | 2019-11-17 19:18:55 | This is your first task. | 2019-12-20 00:00:00 | null | 0 | null | 3 | 50 | 10000 | 57600 | admin | 10000 | 2019-12-17 10:07:58 | null | 10001 | This is your first task | 10000 | 57600 | 2020-03-31 11:02:08 | 0 | 0 | 9223372036854775807 | FALSE | null |
The id condition does not have quotes because it is a numeric numeric (integer) value.
Internally, the SQL+JQL Driver Driver will get the issue id from the WHERE condition and will use it to invoke the Atlassian's API. This query will be performed very quickly taking very few milliseconds.
...