Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom JQL Query in Jira + Smartsheet Connector

Mireille
Contributor
February 15, 2023

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

0 answers

Suggest an answer

Log in or Sign up to answer