report for work items
we have some custom fields for work items .And we need many reports .so I want to develop some reports .
Who can tell me which table store work items information? I can get table name by db2 monitor.but I don't want to do. My db is db2 . |
10 answers
openeis wrote:
we have many custom field for work items .And we need many reports .so Hello, In RTC 1.0, the data warehouse does not store information about custom work item fields. After 1.0 we will investigate some extensibility around this item. In addition, the data sources which operate on "live" data (from the repository, not from the warehouse) do not expose custom fields. Hope this helps. james Jazz Reports Team Lead |
|
I don't understand it.
In general,warehouse data is from operated tables. I needn't know warehouse tables name ,I only know operated tables. For example,when I save a work item,it must insert into data the table, I only need to know this table. |
|
openeis wrote:
I don't understand it. When you save a work item, the data is saved in the repository, but it is not saved in the data warehouse. Periodically, scheduled tasks run and aggregate information about work items (and other artifacts), storing the results in the data warehouse, but this aggregated information does not include custom fields. But I think you're asking about a larger issue, which is access to the underlying database tables in the Jazz repository. This is not currently possible - the underlying structures should be treated as opaque, and data should be accessed through the appropriate APIs, such as the query model. Perhaps someone from the repository team could comment on this. We (the Reports team) do have a mechanism (a custom data source) to connect BIRT-designed Reports to the repository artifacts by means of the query model, but this data source does not currently support the custom fields. Hope this helps. james Jazz Reports Team Lead |
|
Thank a lot.
I understand your comments. And now I know the work item table,but the table data is encrypt.so I don't know how to get report by SQL . who can help me? |
|
I installed M6.And get "Designing a report template with BIRT tools" online help,but the docs is blank.(The Help content is a work in progress)
My question is : Can BIRT tools access all field? |
|
openeis wrote:
I installed M6.And get "Designing a report template with BIRT The help topics are a work in progress. For now, you will find more complete information on designing a report template in the wiki. https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport Your question is a good one, and has two answers: 1. When using BIRT to access the Data Warehouse tables, you can access all the fields that we actually store in the data warehouse. Remember, though, that the warehouse is a storage mechanism for *aggregated*, *historical* data, and as such does not include every field of every artifact in the repository. 2. When using BIRT to access live data from the repository through our special tables (such as the live work item counts table), this support is built using the Jazz query model, which can access only those attributes/fields which are marked as queriable in the respective model. Hope this helps. james |
|
now I don't read docs of report
I want to know how to imp the following daily task report for our team in m6 : categories ownerBy summary(groupbyweek(DueDay)) tags Defect count(tags) note: my tags is failed,complete,blocked,ongoing. now defect is not on rational team concert,after CMVC connector is ready,we need defect number. categoried is part ,not all. I think many reports is easy by SQL,but I don't know team concert report |
|
Hello,
Could you clarify a couple of thing for me? I'm not sure I understand exactly what you're asking. - Are your defects actually in RTC? It sounds like they are currently in CMVC, in which case we can't report on them. - What do you mean by "categoried is part, not all"? - I don't understand the list of criteria (categories, ownerBy...) - could you be more specific about each of them? Maybe it would be helpful if you could post a picture of what you would like the report to look like. Thanks, james Jazz Reports Team Lead openeis wrote: now I don't read docs of report |
|
my example report :
platform tester week1(03/31-04/04) ...w9() (category) tookit_1 tester1 summary of task1 (failed)(defect 99999) Solaris_2 tester2 summary of task2(complete) category include platform and other category. now defect is in CMVC,so now we don't need defect number |
|
openeis wrote:
my example report : The reporting component is currently focused on reporting on data from our data warehouse, which is collected from the Jazz repository. We don't currently have any data sources that would allow you to collect information from CMVC. BIRT does allow you to write custom data sources - perhaps that would allow you to gather data from CMVC. james |
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.