Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Hi James,

I'm having the same problem described in this topic and i didnt understand your last post!!

I didnt find this com.ibm.team.workitem.linktype.timeSheetEntry as a Live Snapshot table, because that was what I understood.

What should I do with that?! Where is it located?

Thanks!

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

How can I access these as "auditable links" in a BIRT report?

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

In BIRT, use the "LINKS" view/table in the COMMON snapshot. LINKS provides a view on all auditablelinks in the system, including the following columns:

LINK_TYPE (e.g. com.ibm.team.workitem.linktype.timeSheetEntry"
SOURCE_ITEMID / SOURCE_URI (One of these two will be specified, depending on whether it's a local link by item id, or a link by URL)
TARGET_ITEMID / TARGET_URI (One of these two will be specified, depending on whether it's a local link by item id, or a link by URL)

james
RTC Reports Team Lead

How can I access these as "auditable links" in a BIRT report?

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Hi James,

thank you, you are right I found the "com.ibm.team.links.AuditableLink" table in LIVE DATA SNAPSHOT, however I still could not find any matching ids between the 2 tables. I tried all auditable links fields containing an id to join with the "com.ibm.team.workitem.TimeSheetEntry" itemId.

Regards,
Alexander

How can I access these as "auditable links" in a BIRT report?

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

Hi James,

thank you, you are right I found the "com.ibm.team.links.AuditableLink" table in LIVE DATA SNAPSHOT, however I still could not find any matching ids between the 2 tables. I tried all auditable links fields containing an id to join with the "com.ibm.team.workitem.TimeSheetEntry" itemId.

Regards,
Alexander

How can I access these as "auditable links" in a BIRT report?

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

According to this:

https://jazz.net/forums/viewtopic.php?p=54599

you need to use "com.ibm.team.links.AuditableLink" table to join "com.ibm.team.workitem.WorkItem" and "com.ibm.team.workitem.TimeSheetEntry"

Please tell me if that works.
Thanks!

Hi mochomocho, related to:

-- --
According to this:

https://jazz.net/forums/viewtopic.php?p=54599

you need to use "com.ibm.team.links.AuditableLink" table to join "com.ibm.team.workitem.WorkItem" and "com.ibm.team.workitem.TimeSheetEntry"

---

I dont see match id's between AuditableLink, WorkItem and TimeSheetEntry

Do you have any suggestions?
Thanks.

Hi James,

thank you, you are right I found the "com.ibm.team.links.AuditableLink" table in LIVE DATA SNAPSHOT, however I still could not find any matching ids between the 2 tables. I tried all auditable links fields containing an id to join with the "com.ibm.team.workitem.TimeSheetEntry" itemId.

Regards,
Alexander

How can I access these as "auditable links" in a BIRT report?

Sorry for the delay, I have tracked down the developers who wrote this part of the REST API.

The link between the Timesheet and the Work Item is stored in the auditableLinks resource. You want links with the name "com.ibm.team.workitem.linktype.timeSheetEntry", which describe this relationship. Thus, in Reportable REST query terminology:

/rpt/repository/foundation?fields=foundation/auditableLink/*/*

james
RTC Reports Team Lead

Any news on this?

Hello James,

thanks for your response. Unfortunatly I have a problem now with running BIRT in my environment.

The problem is that "com.ibm.team.workitem.TimeSheetEntry" table in the LIVE SNAPSHOT view does no contain any direct reference to the related work item number. So there must be somewhere another table with a forign key to perform the join.

Can you please help us to find the correct relation?

Thanks,
Alexander

Hello all,

We are trying to create a BIRT report to display the time tracking
information of specific work items. We therefore want to join the
entries from the "Timesheet Time Code" table in the LIVE DATA SNAPSHOT
view with the work item information in the work item table.

Unfortunatly the work item forign ids in the "Timesheet Time Code"
table are not the same format as the ones in the work item table.

Is there any way to join the two tables? Does js scripting need to be involved?

Any help will be deeply appreciated.

Can you provide more information on exactly which tables you are using, and which columns you are looking at for ids? The work item table exposes both the id (e.g. "1") and the itemid (a UUID), so I was expecting that the timesheet table would use one of those.

Thanks,

james
RTC Reports Team Lead

According to this:

https://jazz.net/forums/viewtopic.php?p=54599

you need to use "com.ibm.team.links.AuditableLink" table to join "com.ibm.team.workitem.WorkItem" and "com.ibm.team.workitem.TimeSheetEntry"

Please tell me if that works.
Thanks!