JQL filter participant

JQ November 9, 2023

hi everyone

I am trying to get the number of tickets that has A or B or C as one of the participants.

  •  issuetype = "Service Request" AND "Request participants" in (A, B, C) >> result = 746 tickets

then I changed to 

  •  issuetype = "Service Request" AND "Request participants" not in (A, B, C) >> result = 1811 tickets

I supposed the 2 numbers would make up the total tickets, but the total service request should be 6000

 

what am I missing here?

should I just consider 6000-1811=4289 as the number of tickets that has A or B or C as one of the participants?

 

thank you in advance!

1 answer

1 accepted

1 vote
Answer accepted
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 9, 2023

@JQ -

Welcome to the community.  For your JQL queries, you should also consider to get a count where "Request participants" field is empty too.  Lastly, when you obtained the count for all "Service Request" issue type issues, are you just using something like this query below? -

issuetype = "Service Request"

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

JQ November 9, 2023

hi Joseph, thank you for your reply!

the full query filter includes: project, issue type, participant, date range

  • project = XXX AND issuetype = "Service Request" AND "Request participants" in (A, B, C) AND created >= 2022-10-01 AND created <= 2023-10-31 order by lastViewed DESC

 

if I understand you correctly-

1.participant include A/B/C (the 746 I mentioned above) + 2.have participant but participant does not include A/B/C (the 1811 I mentioned above) + 3.participant is empty = total ticket count

I got the 3 numbers and curiously the total is 11 less than when I totally removed the particpant filter

it will be great if you could share whats missing again but it should be close enough to give me an overview % already

thank you again!

Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 10, 2023

@JQ -

You are using "In" and "Not In" when you querying for "Request Participant" field right.  You can also use "Is" and "Is Not" to conduct your testing for Empty/Not Empty too.

Best, Joseph

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events