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,460,887
Community Members
 
Community Events
176
Community Groups

Please help identify what the issue is with this script completed in JQL

Edited

Project = PC AND "Epic Link" = PC-151 or "Epic Link" = PC-153 AND issuetype in (standardIssueTypes(), Bug, Epic, Improvement, Story, Task, "Test Case") AND component = "Tempo Timesheets" ORDER BY Rank ASC

 

The result is Epic Link 151 tickets, and Component tickets are populated, However, Epic Link 153 tickets don't populate.

Also, I swapped the order of 151 with 153 and noticed that it picks up whichever is first but not the second one.

 

Please can you advise me on a fix for this?

1 answer

0 votes
Trudy Claspill Community Leader Dec 12, 2022

The problem is your use of the OR operator.

Try this:



Project = PC AND "Epic Link" in (PC-151,PC-153) AND issuetype in (standardIssueTypes(), Bug, Epic, Improvement, Story, Task, "Test Case") AND component = "Tempo Timesheets" ORDER BY Rank ASC

 Or try this:

 

Project = PC AND ("Epic Link" = PC-151 or "Epic Link" = PC-153) AND issuetype in (standardIssueTypes(), Bug, Epic, Improvement, Story, Task, "Test Case") AND component = "Tempo Timesheets" ORDER BY Rank ASC

Hi Trudy,

Thank you for taking the time to respond, unfortunately, both options only return the component only.

Trudy Claspill Community Leader Dec 13, 2022

Hello @Trisha Colotto 

Please provide more information about what you are trying to achieve with the query. Can you describe it in sentences rather than with the query?

What results are you getting? What results are you trying to get?

What is an example of an issue you expect to get in the results that is not showing up? Can you share a screen image that shows the issue type, Components field, and Epic Link field for that issue?

As it is written you will get

1. Issues of type Bug, Epic, Improvement, Story, Task, Test Case, or in the Standard Issue Types group that also

2. are in the PC project and that also

3. have the value "Tempo Timesheets" in the Components field and that also

4. have either PC-151 or PC-153 in the Epic Link field.

What is the type of the PC project? Is it Team Managed or Company Managed? That will be shown at the bottom of the navigation pane on the left. Is it a Software, Service, or Business/Work Management project?

Also, you at least one set of elements that don't go together in this filter.

Epic issues don't have a value in the Epic Link field, so you will not get Epics in your result set. 

Suggest an answer

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

Atlassian Community Events