Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes



One answer

Permanent link
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....

1 vote

Comments

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

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

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,017
× 201
× 57
× 35

Question asked: Dec 17 '14, 12:03 p.m.

Question was seen: 8,431 times

Last updated: Dec 17 '14, 12:33 p.m.

Confirmation Cancel Confirm