Page Comparison

...

select
  i.key as"Issue",
  i.summary as "Summary",
  t.name as "Type", t.url as "TypeUrl",
  s.name as "Status",
  c.colorname as "Status Color", 
  i.resolutionid is not NULL as "Resolved"
from
  ISSUES i
    join
  ISSUETYPEDEFINITIONS t on t.id = i.typeid
    join
  ISSUESTATUSDEFINITIONS s on s.id = i.statusid
    join
  ISSUESTATUSCATEGORYDEFINITIONS c on c.id = s.categoryid
where
  i.jql = ?

Note that the paramter is not enclosed within single quotes. 

Select the Parameters element in the list on the left, then click on the New... buton and fill aout the data in the form as shown below:

Image Added

Run and test the report by providing your own JQL. In our particular case, we provided:

project = SSP

Image Added

And the report is automatically adapted to the new JQL value:

Image Added

Perhaps you are wondering... what about the JIRA Dashboards or Confluence pages? How to set the JQL parameter there? It's quite easy. First encode the JQL by using some thid party tool like this:

Image Added

Edit the gadget and provide the parameters as part of a URL

__parameterpage=false&JQL=project%20%3D%20SSP

Image Added

What is the 

__parameterpage=false

above? It is required by the BIRT viewer to do not open the paramters dialog. You can find more information about the supported BIRT viewer's URL paramters in this page.

The End