Versions Compared

Key

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

...

Note

Please pay attention that SQL do does not allowed allow execute all issues from Jira at once. So you need to put Issue ID or JQL query, that selects issues from a particular place (project, user, sprint, board etc) More details…

...

  1. Select all Issues from a particular project

    Code Block
    languagesql
    select *
    from ISSUE i
    where JQL='project=PROJECTNAME'
  2. Select all Issues of a current user

    Code Block
    languagesql
    select *
    from ISSUE i
    Where JQL='reporter=currentUser()'
  3. Select all Issues from an open sprintssprint

    Code Block
    languagesql
    select *
    from ISSUE i
    where JQL='Sprint in opensprints()'

...