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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.