Jira filtering - check for not existing field

[Robin Peters]

Hello,

I have several projects and some of them uses a field "planned end", some don't.
Now I want to filter all issues for one user where the "planned end" is exceeded or empty or the field does not exist.

"Planned End" <= endOfDay() OR "Planned End" is EMPTY

I have problems to check if the field exists. How can I check for it?

Regards,

Robin

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

What do you mean by field don't exist? "Planned End" is EMPTY should list issues which doesn't have the field populated.

[Robin Peters]

It's a custom field which is not applicable in all of the projects.
It's not just empty, the field isn't existing there.

Yeah, I could set it in the projects and hide it, but then I will have some other problems.

[Jobin Kuruvilla [Adaptavist]]

Unfortunately, hiding it by configuring context is the only option. Not sure how to get it using JQL.

[Robin Peters]

Ok, I enabled und hide the fields. Now the query return the expected issues.