It's all about the answers!

Ask a question

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

Michele Pegoraro (1.8k14119103) | asked Dec 05 '12, 3:18 a.m.
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?


Accepted answer

permanent link
Vladimir Amelin (70472226) | 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:

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

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.

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.