How work items are stored in Repository
![]()
I want to know the ER diagram Or Data Base structure with respect to work items.
Please let me where I can find which tables have what information on work items. I want to use this information for creating new reports. And also I want to know what snapshots has what information |
4 answers
![]() I want to know the ER diagram Or Data Base structure with respect to work items. If you have DBA access any tool( ex: Toad) can create ER Diagram. If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse |
![]()
Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this.
Thanks much for the reply. I want to know the ER diagram Or Data Base structure with respect to work items. If you have DBA access any tool( ex: Toad) can create ER Diagram. If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse |
![]() Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this. I want to know the ER diagram Or Data Base structure with respect to work items. If you have DBA access any tool( ex: Toad) can create ER Diagram. If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse you can download BIRT via eclipse But if you are looking for ER diagram this is not the right approach. If you are looking for queries/reports on workitems then this could be one approach |
![]()
Hi
I downloaded the BIRT and installed it. I want to know how the tables are stored and what table has what data. And I created a report but the report is not showing up. Thanks, _Shashank Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this. I want to know the ER diagram Or Data Base structure with respect to work items. If you have DBA access any tool( ex: Toad) can create ER Diagram. If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse you can download BIRT via eclipse But if you are looking for ER diagram this is not the right approach. If you are looking for queries/reports on workitems then this could be one approach |
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.