How to build complex RTC query combining "AND" "OR" conditions
Hello,
This is a question about the RTC building query in RTC-CLM 5.0.
I would like to create a query with the following criteria:
Find all (unresolved Work Items)
and
((Due date before today’s date) or (Due date is none))
and
((Estimated date before today’s date) or (Estimated date is none))
and
((Due date is not none) or (Estimated date is not none))
I already browse this good article https://jazz.net/library/article/1007 but I’m sure what we want can be
done.
In particular I’m not too familiar how to combine the “And” and “Or” condition?
Have you other good tips to do such queries
Thank you in advance
Pascal Jean
One answer
You have a good structure there, which tells you the different groups.
Start with a query from scratch.
Your "outer" group is an AND, since it is status is unresolved AND <blah> AND <blah> AND <blah>
Add a condition that is for Status is Unresolved.
Then add an OR GROUP (same add + but select OR GROUP). You can actually do that 3 times, so you would have an outer group that at the top says AND, then your Unresolved, and below the unresolved (same indenting) you have 3 groups that at the top say OR in each.
Then inside the OR group lines, you add 2 conditions one for, say, Due date Unassigned and then another for Due date before (including) 1 day ago relative date.
Here is what mine started looking like (i didn't do all the boxes)...see if this helps....
Start with a query from scratch.
Your "outer" group is an AND, since it is status is unresolved AND <blah> AND <blah> AND <blah>
Add a condition that is for Status is Unresolved.
Then add an OR GROUP (same add + but select OR GROUP). You can actually do that 3 times, so you would have an outer group that at the top says AND, then your Unresolved, and below the unresolved (same indenting) you have 3 groups that at the top say OR in each.
Then inside the OR group lines, you add 2 conditions one for, say, Due date Unassigned and then another for Due date before (including) 1 day ago relative date.
Here is what mine started looking like (i didn't do all the boxes)...see if this helps....
