Page Comparison

...

1. Select all Issues from a particular project

   Code Block
   language sql
   select * from ISSUE i where JQL='project=PROJECTNAME'

2. Select all Issues of a current user

   Code Block
   language sql
   select * from ISSUE i Where JQL='reporter=currentUser()'

3. Select all Issues from an open sprintssprint

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

...