I am trying to write a Custom JQL Query in Smartsheet+Jira Connector that is using more than one project (5). When I only have 1 project, the UI is nice and you add filters; so it would be like:
Issue Type: ---does not include --Bug, Feature, Sub-Tasks
Status: ---includes--Cancelled, Closed, Deferred.
Epic Link: includes SRMP-270, SRMP-271, SRMP, 272
Now, with 5 projects, I can only add to the default custom JQL: project in ('ISR', 'RAY', 'SRMP', 'TESCO', 'TTLII')
and (
Status = Cancelled or Status = Closed or Status = Done
) order by id
I tried a few combination of AND and OR, without the expected result to only see from these 5 projects the issues type (Epic, Story, Task) only from Epic links SRMP-270, SRMP-271, SRMP, 272 that are Cancelled Closed or deferred.
Let me know if there is an easy one line that adds on to project in ('ISR', 'RAY', 'SRMP', 'TESCO', 'TTLII')
thank you