Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,735
Community Members
 
Community Events
176
Community Groups

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

2 answers

1 accepted

6 votes
Answer accepted

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

0 votes

Enter the appropriate JQL query. Issues that pass this query will remain in the structure.

When checked, non-issue items, such as folders, will remain in your structure regardless of whether or not they match your filter criteria.

If this option is selected, all issues that match your filter criteria will be included in the structure, along with any sub-items of those issues.

You can apply a filter to specific levels within your hierarchy. For example, you may want to include all top-level items, but then filter the stories beneath them.

Hi, @Carlene Lee. Welcome to the community! 👋

It looks like you may be using the Atlassian Marketplace app, Structure.  However, it's not clear that @Victor Tobon is 😊

Nonetheless, thank you for your suggestion!

-dave

P.S. By the way, I work for the company that makes Structure. It would be great to connect with you. You can find me easily on LinkedIn.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS

Atlassian Community Events