Is it possible to reach the oracle DB?
Accepted answer
@Ziv accessing the WI's directly from database is not possible. The WI data and history etc are stored in a Blob column as a gzipped xml.
The best way would be to use the export a WI query as a csv and open in excel.
If you have defined the same query with output fields in the 2 PA's you can append 1 excel to the cells of the other.
The best way would be to use the export a WI query as a csv and open in excel.
If you have defined the same query with output fields in the 2 PA's you can append 1 excel to the cells of the other.
One other answer
Hi Riz,
Accessing the backend database directly won't make anything easy for retrieving the workitems. Instead it would probably be easier if you create same query structurally and export the results from different project areas.
Accessing the backend database directly won't make anything easy for retrieving the workitems. Instead it would probably be easier if you create same query structurally and export the results from different project areas.
Comments
Thanks,
We have project manager that manage to different ProjectAreas.
I want to give him the capability to see WIs from two ProjectsAres in one place (excle or one of the RTC client), is it possible?
It is possible to get straight to the RTC DB tables at all?
Ziv
Getting straight to the db tables and retrieve right information would expect you to know the relationship between all relevant tables to form a query and I would consider that a quite time consuming and fairly complex task. As I said, you can just right click on the query from your respective project areas and export to a csv format and open in excel