It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,877
×12,004
×368
×201

question asked: Dec 05 '12, 3:18 a.m.
question was seen: 4,907 times
last updated: Dec 05 '12, 4:26 a.m.

Related questions

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

0
Michele Pegoraro (1.8k●14●119●103) | 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

0
permanent link
Vladimir Amelin (704●7●22●26) | 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.


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.