Jira filters not working for test cycles

[Akash L]

The whole query is:

project = "Detailed Test Procedures" AND fixVersion = "TCDU RED LABEL" AND cycleName in ("TCDU RL9") ORDER BY summary ASC

However, some tests show up and some that are older than a certain date do not show up. Is this because the query factors in how old a test is?

APDTP-14 below is an example an issue that the filter is not showing but should be.

ExampleIssue1TestExecutions.png below is the test executions section for APDTP-14, the issue that is not showing but should be.

APDTP-78 below is an example an issue that the filter is not showing but should be.

ExampleIssue2TestExecutions.png below is the test executions section for APDTP-78, the issue that is not showing but should be.

APDTP-19 below is an example an issue that the filter is showing, and should be.

ExampleIssueShowing1TestExecutions.png below is the test executions section for APDTP-19, the issue that is showing and should be.

APDTP-79 below is an example an issue that the filter is showing, and should be.

ExampleIssueShowing2TestExecutions.png below is the test executions section for APDTP-79, the issue that is showing and should be.

[Bill Sheboy]

Hi @Akash L 

Your query does not include anything about date, so age of the issues should not impact the results.

When you look at items that do not match, but that you expect to be returned, do they in fact have all of the criteria from the query: project, fixVersion, and cycleName?

Kind regards,
Bill

[Akash L]

I noticed in two instances of issues not showing up from the filter, if I simplify the query to just

project = "Tests" 

The two omitted issues still do not appear in that list. Those two issues very clearly are part of the project "Issues" when I click on the issues. They are nearly identical to the issues that do appear with that filter. Those two issues have an "updated" date that is older than the other issues, but I am not sure that is causing the issue. Is there a suggestion you have as to how I can dive deeper and figure out why this is happening?

[Bill Sheboy]

Can you confirm you are in fact using Jira Cloud, and not Jira Server or Data Center?

Can you show a screen image of your list of projects, focusing on any with names similar to the one in you query?

Can you show a screen image of the two issues you believe to be in the project and which are not returned by that simple query of project = "Tests"

[Akash L]

Hi Bill,

I believe I am actually on Jira Server.

Sure, I have attached screen captures to this post. I have edited the post with the full query and included screencaptures with captions

Here is the full query:

project = "Detailed Test Procedures" AND fixVersion = "TCDU RED LABEL" AND cycleName in ("TCDU RL9") ORDER BY summary ASC

In the screenshots,

- APDTP-14 and APDTP-78 are examples of issues that the filter is not showing but should be.

-ExampleIssue1TestExecutions.png and ExampleIssue2TestExecutions.png are the test executions sections of the issues APDTP-14 and APDTP-78, the issues that are not showing but should be.

- APDTP-19 and APDTP-79 are examples of issues that the filter is correctly showing.

- ExampleIssueShowing1TestExecutions.png and ExampleIssueShowing2TestExecutions.png are the test executions sections of APDTP-19 and APDTP-79, examples of two issues in which the filter is correctly showing.

[Bill Sheboy]

Thanks for clarifying that you are using Jira Server.  It is possible this is a search indexing issue with the database, so please work with your site admin to re-index the database to see how that helps: https://confluence.atlassian.com/adminjiraserver/re-indexing-after-major-configuration-changes-938847716.html

[Akash L]

Thanks for that answer. The team had recently found a work-around in which they updated by updating each DTP since only the recently updated DTPs were showing on that test cycle.

I believe a re-index would have worked as well. Thank you for your input, we will be using this information moving forward.

[Vamsi Kandala]

Hi @Akash L

Yes, based on the JQL query, the results will have the tickets which contain the 'fixVersion' as 'RED LABEL' as well as the 'cycleName' containing 'RL9'. 

Are you specifying date periods for the 'cycleName' field?  If so, does the tickets were returned fall within this time period?

Hope this helps.

Thanks,
Vamsi

[Akash L]

I noticed in two instances of issues not showing up from the filter, if I simplify the query to just

project = "Tests" 

The two omitted issues still do not appear in that list. Those two issues very clearly are part of the project "Issues" when I click on the issues. They are nearly identical to the issues that do appear with that filter. Those two issues have an "updated" date that is older than the other issues, but I am not sure that is causing the issue. Is there a suggestion you have as to how I can dive deeper and figure out why this is happening?