It's all about the answers!

Ask a question

Is it possible to write queries across Project Areas?


Harish Chandar (611) | asked Jul 24 '14, 3:37 a.m.
I would like to know if it is feasible to write queries across 2 Project Areas. I have work items linked where Child is in 1 Project Area and Parent is in another Project Area.

2 answers



permanent link
Ralph Schoon (63.1k33645) | answered Jul 24 '14, 3:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Harish,

as far as I know this is currently not possible. This is a popular request however.

The problem with doing it is, each project area has potentially a different process definition with different attribute specifications. Not even attributes with the same ID are necessarily comparable, or provide the same values.

permanent link
Francesco Chiossi (5.7k11119) | answered Jul 25 '14, 4:41 a.m.
edited Jul 25 '14, 4:41 a.m.
Hello Harish,

an alternative to get data from multiple project areas would be using a reporting solution like RRDI, Insight or RPE.
You can also directly query the data warehouse database.
The limitation in this case is that you only have access to a subset of the information that a query can give you.

Jazz Reporting Service is also a promising solution, but at the current release only provide OOTB reports support
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.0/com.ibm.team.jp.jrs.doc/topics/c_jrs_intro.html

Best Regards,

Francesco Chiossi

Your answer


Register or to post your answer.