It's all about the answers!

Ask a question

How to query work items across project area by SQL?


Eric Jodet (6.3k5111120) | asked Jun 18 '12, 4:07 a.m.
JAZZ DEVELOPER
I want to know how to query work items across project area.
According to following topic on forum, it may possible by using Query API.
https://jazz.net/forum/questions/14778/querying-work-items-spanning-across-multiple-project-area

Besides it, I want to know SQL with which I can query work items across project area,
so that I can run it on DB2 command editor.

Accepted answer


permanent link
Eric Jodet (6.3k5111120) | answered Jun 18 '12, 4:08 a.m.
JAZZ DEVELOPER
Querying work items across project area using SQL queries is currently not supported.
However - as the above topic underlines - this can be achieved programatically using Work Item API
https://jazz.net/wiki/bin/view/Main/QueryDevGuide
and/or using OSLC - https://jazz.net/wiki/bin/view/Main/WorkItemAPIsForOSLCCM20
Seth Packham selected this answer as the correct answer

Comments
Madhan Babu commented Dec 17 '12, 8:25 a.m.

How can it be not possible to query with SQL on a DB?
If we know the DB Schema used by RTC, then with the DB server url, it must be possible to fetch the work items right? or am i missing something here?

Is there any possibility to know the DB schema used by RTC?

Best regards
Madhan


Eric Jodet commented Dec 17 '12, 8:28 a.m.
JAZZ DEVELOPER

Hello Madha,
sorry - I did not say "not possible",
rather "not supported" (or advisable).
Thanks


Guido Schneider commented Dec 14 '16, 10:03 a.m.

Today with Report Builder you can build such queries and see in Advanced the SQL statement.


Kevin Ramer commented Dec 14 '16, 1:20 p.m.

To Madhan: Even given information about the schema, there are security considerations as Jazz applications add a protective layer above the database ( e.g. Access Control on project area ).   Having a "direct" sql pipeline will, by default, bypass that.


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.