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.
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.

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.
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
and/or using OSLC -
Seth Packham selected this answer as the correct answer

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

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

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

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.