How to query work items across project area by SQL?

Eric Jodet (6.3k●5●111●120) | 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.3k●5●111●120) | 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.

It's all about the answers!

Related questions

How to query work items across project area by SQL?

Accepted answer

Your answer