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 |
Accepted answer
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 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. |