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

[Trisha Colotto]

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?

[Trudy Claspill]

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

[Trisha Colotto]

Hi Trudy,

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

[Trudy Claspill]

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.