Issue to get result with a filter

[Franck PASSIER]

Hello,

The issue returned (same problem as here).

When I use a filter, the result can't be displayed.

==
Error : 

We couldn't load your search results.

Refresh to try again

==

status was in (***,***,***,***)

AND status NOT IN (Rejected, Done, Resolved, Closed)

I have to add "and createdDate >= startOfDay(-400)" to get a result

Only 70 tickets are affected so, I don't understand why JIRA can't displayed these.

Can you help me ? 

[Humashankar VJ]

Hi @Franck PASSIER 

To troubleshoot, simplify the query by isolating variables. Begin by testing the status filter exclusively, using the following parameters:

status was in (***,***,***,*) AND status NOT IN (Rejected, Done, Resolved, Closed)

See if you get results without the date filter.

Best Regards

[Franck PASSIER]

Hi @Humashankar VJ 

Thank you for your answer.

If i try : 

• status was in (***,***,***,***) : No results
• status was in (***,***,***,***) AND status NOT IN (Rejected, Done, Resolved, Closed) : No results
• status was in (***,***,***,***) AND status NOT IN (Rejected, Done, Resolved, Closed) AND createdDate >= startOfDay(-400) : I have 71 results

Additional information : 

The second filter works in a Dashboard if I ask only the number of results.

[Humashankar VJ]

@Franck PASSIER 

Out of my closer look from your datapoints, few set of pointers to notice

Primarily, the sudden appearance of results upon adding a date constraint hints at issues with how JIRA handles older issues or maintains its index over time.

Then, discrepancies between dashboard results and the issue navigator suggest problems with how JIRA processes or displays results in different contexts.

To conclude, the dashboard displaying counts but not full results in the issue navigator indicates potential issues with result retrieval or display, rather than the query itself.

[Humashankar VJ]

To add a few on the root cause:

One possibility is indexing problems, where the index may be incomplete or corrupted, particularly for older issues.

Another cause could be differences in search implementation between dashboards and the issue navigator.

[Franck PASSIER]

Is there a solution about my issue ? 

PS : this request worked fine before (without CreatedDate filter)

[Humashankar VJ]

Hi @Franck PASSIER 

As stated in the thread Issue with Filter, unsure how things are managed from the backend. We also have to wait find the confirmation from the authorized personal on this is what i believe.