It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,459

question asked: Jan 24 '12, 4:19 a.m.
question was seen: 4,088 times
last updated: Jan 24 '12, 4:19 a.m.

Related questions

RRDI Reporting- Inconsistency with workitem ID and URL

0
Bharath M (546●54●28) | asked Jan 24 '12, 4:19 a.m.
Hi,

I'm trying to create a simple list report using RRDI, that displays Workitem ID, Project Area, WI Type, Owner and Summary.

I have selected these columns from Request Area. But for some reason, the Workitem ID (Request ID) and the remaining data does not match.

For eg:
WI ID | Project Name | Type | Owner | Summary
24608 | IS - Business Glossary | Defect | Shlomit Becker | test

In the above example, WI_ID#24608 doesn't relate to Business GLossary project at all.

Also, if I display URL, the url contains correct WI_ID. So basically, except WI_ID, every other column is correct.

Any clue what I might be doing wrong?

Thanks,
Bharath

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jared Russell (1.3k●1●20●19) | answered Jan 24 '12, 6:21 a.m.
In the data warehouse the Request ID is a unique ID generated by the DW, and is not related to the work item ID in the source application (RTC).

The identifier generated by RTC is stored in the column named Reference ID in the DW.

Hi,

I'm trying to create a simple list report using RRDI, that displays Workitem ID, Project Area, WI Type, Owner and Summary.

I have selected these columns from Request Area. But for some reason, the Workitem ID (Request ID) and the remaining data does not match.

For eg:
WI ID | Project Name | Type | Owner | Summary
24608 | IS - Business Glossary | Defect | Shlomit Becker | test

In the above example, WI_ID#24608 doesn't relate to Business GLossary project at all.

Also, if I display URL, the url contains correct WI_ID. So basically, except WI_ID, every other column is correct.

Any clue what I might be doing wrong?

Thanks,
Bharath
0
permanent link
Bharath M (546●54●28) | answered Jan 24 '12, 6:41 a.m.
In the data warehouse the Request ID is a unique ID generated by the DW, and is not related to the work item ID in the source application (RTC).

The identifier generated by RTC is stored in the column named Reference ID in the DW.

Hi,

I'm trying to create a simple list report using RRDI, that displays Workitem ID, Project Area, WI Type, Owner and Summary.

I have selected these columns from Request Area. But for some reason, the Workitem ID (Request ID) and the remaining data does not match.

For eg:
WI ID | Project Name | Type | Owner | Summary
24608 | IS - Business Glossary | Defect | Shlomit Becker | test

In the above example, WI_ID#24608 doesn't relate to Business GLossary project at all.

Also, if I display URL, the url contains correct WI_ID. So basically, except WI_ID, every other column is correct.

Any clue what I might be doing wrong?

Thanks,
Bharath


Thanks Jared. I'm really confused with this terminology now. Is there a document that lists out RTC fields and equivalent DW columns?
0
permanent link
Jared Russell (1.3k●1●20●19) | answered Jan 24 '12, 7:11 a.m.
See this page of the documentation. Alternatively there's a spreadsheet with the same info.

In the data warehouse the Request ID is a unique ID generated by the DW, and is not related to the work item ID in the source application (RTC).

The identifier generated by RTC is stored in the column named Reference ID in the DW.

Hi,

I'm trying to create a simple list report using RRDI, that displays Workitem ID, Project Area, WI Type, Owner and Summary.

I have selected these columns from Request Area. But for some reason, the Workitem ID (Request ID) and the remaining data does not match.

For eg:
WI ID | Project Name | Type | Owner | Summary
24608 | IS - Business Glossary | Defect | Shlomit Becker | test

In the above example, WI_ID#24608 doesn't relate to Business GLossary project at all.

Also, if I display URL, the url contains correct WI_ID. So basically, except WI_ID, every other column is correct.

Any clue what I might be doing wrong?

Thanks,
Bharath


Thanks Jared. I'm really confused with this terminology now. Is there a document that lists out RTC fields and equivalent DW columns?

Your answer

Register or to post 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.