You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
I need some help writing a seemingly complex query that combines 3 separate queries.
My ultimate goal is to identify all asset records that are missing data for required fields in our Jira Insight.
These are the required fields:
Country
Assigned To
Email ID
Asset Status
Cost
Depreciated Cost
Purchase Date
PC Type
Location
My query for these required fields:
"Country" IS empty OR "Assigned To" IS empty OR "Email ID" IS empty OR "Asset Status" IS empty OR "Cost" IS empty OR "Depreciated Cost" IS empty OR "Purchase Date" IS empty OR "PC Type" IS empty OR "Location" IS empty
Now for the complex part.....
There are 2 countries (India & Nepal) that have an additional required field - "Financial ID".
I've been able to write a query each for India & Nepal (below).
2nd query (India):
"Financial ID" IS EMPTY AND "Country" IN ("India") OR "Assigned To" IS empty OR "Email ID" IS empty OR "Asset Status" IS empty OR "Cost" IS empty OR "Depreciated Cost" IS empty OR "Purchase Date" IS empty OR "PC Type" IS empty OR "Location" IS empty
3rd query (Nepal):
"Financial ID" IS EMPTY AND "Country" IN ("Nepal") OR "Assigned To" IS empty OR "Email ID" IS empty OR "Asset Status" IS empty OR "Cost" IS empty OR "Depreciated Cost" IS empty OR "Purchase Date" IS empty OR "PC Type" IS empty OR "Location" IS empty
Can anyone suggest 1 query that combines all 3?
Thanks in advance!
Hi @Cooke_ Terri ,
welcome to the Atlassian Community!
Hopefully I got it right, but I would do something like:
("Assigned To" IS EMPTY OR "Email ID" IS EMPTY OR "Asset Status" IS EMPTY OR "Cost" IS EMPTY OR "Depreciated Cost" IS EMPTY OR "Purchase Date" IS EMPTY OR "PC Type" IS EMPTY OR "Location" IS EMPTY) OR ("Country" IN ("Nepal", "India") AND "Financial ID" IS EMPTY)
Find all records with empty fields (for all countries including Nepal and India) and add also the ones for Nepal and India, which have Financial ID empty...
Hana - you are a lifesaver! Thank you - huge sigh of relief! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
During my 17 years as a coach, mentor, and trainer of Agile teams, I’ve participated in hundreds of Agile planning meetings. The end result was a wall of backlog items annotated by an explosion of co...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.