JQL filter participant

[Scarlett Qi]

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!

[Joseph Chung Yin · Accepted solution]

@Scarlett Qi -

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.

[Scarlett Qi]

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]

@Scarlett Qi -

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