It's all about the answers!

Ask a question

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


Michele Pegoraro (1.8k12110101) | asked 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

Accepted answer


permanent link
Vladimir Amelin (70462126) | answered 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

Comments
Michele Pegoraro commented 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 commented 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 to post your answer.