It's all about the answers!

Ask a question

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

Michele Pegoraro (1.8k12116103) | 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.