Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

All query examples written in grey boxes are active. You can easily copy them and insert into your Query Console to test. Icon “Copy” appears when your cursor gets into grey query box.

Try me:

Code Block
languagesql
SELECT LINKISSUE(i.`KEY`) as 'Issue' 
FROM ISSUE i 
WHERE  JQL='assignee = currentUser()'

Info

Please pay attention that all chains (like JQL, new names of columns, for example) must be couted with a singl cuotes ' '

Info

Dont forget about reserved key words in SQL, that must be cuoted with reverse accents, like this

`KEY WORD `