Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL generation?

Edited

Good morning community,


I ask your help to generate a jql Filter since I have this as general

project in ("IT Service Desk", "ER-Data Factory", HANA) AND (assignee in membersOf (ExtInc_Benefits) OR project in ("IT Service Desk", "ER-Data Factory", HANA) AND assignee in membersOf ("Kanban Transversal") OR project in ("IT Service Desk", "ER-Data Factory", "Help Desk", HANA) AND assignee in membersOf (" MDP Online ") OR project in (" IT Service Desk "," ER-Data Factory ", HANA) AND assignee in membersOf (" MDP TC3 ") OR project in (" IT Service Desk "," ER-Data Factory ", HANA) AND assignee in membersOf ("Ticket Car") OR project in ("IT Service Desk", "ER-Data Factory", HANA) AND assignee in membersOf (OPAM) OR project in ("IT Service Desk", "ER -Data Factory ", HANA) AND assignee in membersOf (Business) OR assignee in membersOf (WarRoom) OR project in (" IT Service Desk "," ER-Data Factory ", HANA) AND assignee in membersOf (AS400)) AND issuetype not in (Users, Affiliates, Problem) AND createdDate> startOfMonth (-1) A ND createdDate <startOfMonth ()

 

that gives me a total of 3797, but when I want to get those that comply with SLA and those that do not comply with it but do not match the total, someone could tell me if there is another way to search or perform the colsuta.

I share the filters  

project in ("IT Service Desk", "ER-Data Factory", HANA) AND (assignee in membersOf(ExtInc_Benefits) OR assignee in membersOf("Kanban Transversal") OR assignee in membersOf("MDP Online") OR assignee in membersOf("MDP TC3") OR assignee in membersOf("Ticket Car") OR assignee in membersOf(OPAM) OR assignee in membersOf(Empresarial) OR assignee in membersOf(WarRoom) OR assignee in membersOf(AS400)) AND issuetype not in (Usuarios, Afiliados, Problem) AND createdDate > startOfMonth(-1) AND createdDate < startOfMonth() AND ("Time to first response" = running() AND "Time to resolution" != breached() OR "Time to first response" = paused() AND "Time to resolution" != breached() OR "Time to first response" = completed() AND "Time to resolution" != breached() OR "Time to first response" = breached() AND "Time to resolution" != breached() OR "Time to close after resolution" = breached() OR "Time to close after resolution" != breached() OR "Time In Validation" = breached() OR "Time In Validation" != breached()) 

this is the one with the compliments and this for the unfulfilled 

project in ("IT Service Desk", "ER-Data Factory", HANA) AND (assignee in membersOf(ExtInc_Benefits) OR assignee in membersOf("Kanban Transversal") OR assignee in membersOf("MDP Online") OR assignee in membersOf("MDP TC3") OR assignee in membersOf("Ticket Car") OR assignee in membersOf(OPAM) OR assignee in membersOf(Empresarial) OR assignee in membersOf(WarRoom) OR assignee in membersOf(AS400)) AND issuetype not in (Usuarios, Afiliados, Problem) AND createdDate > startOfMonth(-1) AND createdDate < startOfMonth() AND "Time to resolution" = breached() 

when adding the total of both filters does not give me the general filter number missing 312 tickets

1 answer

Hi @Victor Tobon 

Please let us know exactly which issues you would like to filter using those JQLs. It would be much easier to create a JQL understanding its purpose.


I see few problems with provided JQL.

  • You use different projects and groups in those queries. For example you have "Help Desk" project in first JQL query that do not exist in following queries. You also use for example Empresarial group in second and third query that do not exist in first one.
  • You have some duplicates in your queries. For example you use something like
    project in (AAA,BBB) AND (project in (AAA,BBB) AND assignee in membersOf(XXX) OR ...)
    You dont have to use second project statement - its redundant in this context to that fiirst one.
  • Your JQL query is not optimized and therefore hard to read and understand. For example instead of using:
    project in (AAA,BBB) AND assignee in membersOf(XXX) OR project in (AAA,BBB) AND assignee in membersOf(YYY)
    you can write:
    project in (AAA,BBB) AND assignee in (membersOf(XXX),membersOf(YYY))

Regards,
Piotr

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

618 views 5 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you