How can I get from the table WORK_ITEM of Jazz db the iteration for
which item is planned?

I try a write a simple query but I don't found the join between tables
WORK_ITEM and ITERATION.

Any suggestions?

Thanks

Hello Ralph,
I trying to create a simple query but not in the tool, I must create a
new BIRT report with JDBC Data Source and I want retrieve the
iteration by a entry in the table WORK_ITEM.
Thanks Andrea

rschoonwrote:

Hello aianni,

I am not sure what you are trying to do. Are you trying to extend

RTC or

just trying to create a simple query?

To create a workitem query in the tool (not programmatically) go to

the Work

Items/My Queries in the Team Artefacts view (just ome spot) Select

create

query and use a simple one to get started. the Iteration can be

found in

the planned for attribute you'd select on the Result Layout Tab of

the query.

https://jazz.net/learn/articles.jsp shows a good overview about the

tools

capabilities.

Ralph

How can I get from the table WORK_ITEM of Jazz db the iteration for
which item is planned?

I try a write a simple query but I don't found the join between

tables

WORK_ITEM and ITERATION.

Any suggestions?

Thanks