Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter error

arno
Contributor
June 14, 2023

Hi All

I created a filter statement in jira as follows:

priority in (Highest-最高, Highest) AND (filter = 25667 0R filter = 25666 OR filter = 25669 OR filter = 25668 OR filter = 25670)

filter.png

The displayed result is normal, but when I save and share with others, the interface prompts an error, as follows: When I visit this filter again, I also visit 500 errors, I would like to ask what is the specific reason

500.png

3 answers

0 votes
John Funk
Community Champion
June 19, 2023

Hi Arno,

Do you have a lot of custom fields? And do those custom fields have a Context that identifies specific project(s) used by that custom field? I used to get 500 errors all of the time until I added a context to all of my custom fields to identify the project and/or issue type using the Custom Field. 

0 votes
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 14, 2023

The page also should contain a stacktrace at the bottom with actual information.

If not, then also the {{ jira_home }}/log/atlassian-jira.log will contain the exception with the stacktrace to tell the story.

500 is such a generic error code that it can be anything, and you cannot do anything without the log, because the log (subsequently, the exception/stacktrace) is the only thing that can tell what happened.

Judging from the sticks, probably it's due to special characters, but again, it's a guess, the log knows more.

arno
Contributor
June 14, 2023

Hi @Radek Dostál 

Thank you for your reply

I inquired in the log according to what you said, and did prompt an error. The error information is as follows

error.png

In addition, I checked each filter, and the JQL statement for one filter is (filter! = 20099 AND filter = 25366 AND filter ! = 23650 AND created < -60d), this filter access will prompt the same error, when I create a filter myself, use this query, I directly access the corresponding link (url/issues/? filter=26337), and an error message is also displayed, but I can find the corresponding result

26337-1.png26337-2.png

Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2023

Kind of self-explanatory in that case. One or more of the filters contains "WAS_IN" operator which is not supported.

0 votes
Mohamed Benziane
Community Champion
June 14, 2023

Hi,

Can you show the error message displayed on the page of your second screenshot or look at you log.

May be you're running in to the same issue here

arno
Contributor
June 14, 2023

Hi @Mohamed Benziane 

Thank you for your reply

I tried this, but it didn't solve my problem

Mohamed Benziane
Community Champion
June 19, 2023

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events