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!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL filter participant

JQ_p3wqj8

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!

Accepted answers

Joseph Chung Yin

@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.

All comments

Joseph Chung Yin

@JQ -

issuetype = "Service Request"

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

JQ_p3wqj8

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

@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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-server

jira-service-management

jira-service-management-server