Is it possible to use and/or for filtering when building views in JPD

[Ant Farley]

Hi, when building out different list views, is it possible to use OR filtering as opposed to AND at all? Looking at a use case of three different Owner types in distinct fields and articulating when any of those three are blank for example

[Bill Sheboy · Accepted solution]

Hi @Ant Farley 

I do not believe that is possible yet.  And, I do not see it on the JPD public roadmap:

https://atlassian-product-managers.atlassian.net/jira/discovery/share/views/a0af4caf-5f1b-42be-8c57-24d1080122bc

One possible workaround, depending upon your license level, is using a custom field and automation rules:

• add a custom field to reflect the condition result, with AND, OR, etc.
• change your view filter to use the custom field to select the work items to display

The reason this depends upon your license level is the amount of automation usage capacity you have.  Please check with your Product Admin to learn more as you likely will need multiple automation rules to keep the custom field value always-up-to-date, versus using a scheduled trigger rule to update the field periodically.

Kind regards,
Bill

[Tanguy Crusson]

Hi, the way we're going to address this is by adding an option to use JQL in the view configuration. That's on the public roadmap in "up next"

[Bill Sheboy]

Thanks, @Tanguy Crusson !!