It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,879
×12,005
×201
×57
×35

question asked: Dec 17 '14, 12:03 p.m.
question was seen: 8,356 times
last updated: Dec 17 '14, 12:33 p.m.

Related questions

How to build complex RTC query combining "AND" "OR" conditions

0
Pascal Jean (60●1●30●41) | asked Dec 17 '14, 12:03 p.m.
edited Dec 17 '14, 12:07 p.m.

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

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Susan Hanson (1.6k●2●201●194) | answered Dec 17 '14, 12:15 p.m.
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....
Comments
sam detweiler commented Dec 17 '14, 12:24 p.m.

and I answered similarly in the other post you created on the same topic

Pascal Jean commented Dec 17 '14, 12:33 p.m.

Thank you Susan,
I think we have good starts to build the quer.
Pasca Jean

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.