I want to display some insight on dashboard where in I want to search issues based on custom field 'Environment' (have values Prod or Test).
-> If the status is Done for issue in Prod then retrieve the issue
-> if not Done in Prod then retrieve the Issue Done in Test
is it possible with JQL ?
Hi @Sahil Dhamija Try to below query :-
project= Test AND ( (status = Done AND Environment = Prod) or (Environment =Test AND status = Done))
JIRA not support conditional JQL.
thanks
Hi, @Sahil Dhamija !
Welcome to the Community!
We need more information about your processes... Do you create different issues to "prod" and "test" environment? Do you linking them?
What does "retrieve the issue" mean? You can show 2 different gadgets, where users will know what to do with each gadgets results(if we are talking about "Filter Result"-gadget).
As for JQL... of course you can use all fields in JQL.
Look through the official documentation - What is advanced searching in Jira Cloud?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.