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?

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


Accepted answer

Permanent link

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

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?

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.

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,014
× 368
× 201

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

Question was seen: 4,945 times

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

Confirmation Cancel Confirm