TIPS & TRICKS for building queries

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:

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

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

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

`KEY WORD `

Vision SQL for Jira

TIPS & TRICKS for building queries

Analytics

Related content