Cannot enter entire JQL in Jira Report

[Clare Lawson]

Hello. I am trying to use the JIRA Report Template in Confluence.  When I copy/paste my JQL, it is getting cut off.  The JQL is :

project in (SD, IMP) AND issuetype in standardIssueTypes() AND status in (Closed, "Closed - No Build Required", "Customer Review", "Customer Validation", "Developer Queue", Escalated, "Follow Up Internal", "In Progress", "Information Requested", "Need information", Open, Ready, "Ready To Close", Reopened, "Waiting for customer", "Waiting Internal") AND "Customer and Terminal[Select List (cascading)]" in cascadeOption(10221) order by created DESC

but when I try to copy/paste to set up the report, it cuts the JQL off in the middle of "need information"

[Marc - Devoteam · Accepted solution]

Hi @Clare Lawson 

I thought that there is a character limit in Confluence macro's.

Is it necessary in your JQL to specify all the statuses?

If so then it would be more useful to maybe exclude the statuses you won't need.

project in (SD, IMP) AND issuetype in standardIssueTypes() AND status not in (<statuses not needed>) AND "Customer and Terminal[Select List (cascading)]" in cascadeOption(10221) order by created DESC

[Clare Lawson]

THANK YOU :)