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

Is it possible to create a query with comparison between fields?

Questions
Tags
Users
Badges
Michele Pegoraro
(1.8k●14●119●103) Dec 05 '12, 3:18 a.m.
Hi,
I need to create a query that compare two different fields on the same work-item. For example: a query that find all the work items with closure date after the due date.

Is it possible?

Thanks,
Michele

0 votes

1 answer
4,963 views
0 votes

Accepted answer

Permanent link
Vladimir Amelin
(704●7●22●26) Dec 05 '12, 4:02 a.m.

I don't think it's possible with RTC queries. You have to create custom reports or add third attribute and use script to store difference between dates like here:

https://jazz.net/wiki/bin/view/Main/AttributeCustomization#Script_based_calculated_values

Another way is to export pre-filtered work items to csv and compare dates in spreadsheet application.

Michele Pegoraro selected this answer as the correct answer

0 votes

Comments
Michele Pegoraro
Dec 05 '12, 4:11 a.m.

Ok, I have clear how to do it with a third attribute. With custom reports, you are saying to create a new report with BIRT, I suppose. Is it correct? Are there other ways to do it?

Vladimir Amelin
Dec 05 '12, 4:26 a.m.

BIRT is a quick way, no need to install something on server side.

But there is Cognos (RRDI\Insight) option also.

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.

Ask a question
Guidelines
FAQ
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,019
× 369
× 201

Question asked: Dec 05 '12, 3:18 a.m.

Question was seen: 4,963 times

Last updated: Dec 05 '12, 4:26 a.m.

Confirmation Cancel Confirm