It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788
×11,929
×7,386
×1,682
×489

question asked: Mar 17 '17, 2:55 p.m.
question was seen: 2,364 times
last updated: Apr 21 '17, 2:02 p.m.

Related questions

FAQ - How this Forum works

COGNOS Query Studio - Cannot Find RTC Field - "Filed Against"

0
Dave Griffin (16●3) | asked Mar 17 '17, 2:55 p.m.

Hey Guys and Gals,

I'm trying to add a column in my RRDI report using query studio. The field I'm trying to find in the RTC "Filed Against" field. In RTC it's populated by entering Work Item Categories.

Can anyone point me in the right direction?

Thanks,

Dave

One answer

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
Kevin Ramer (4.5k●8●183●200) | answered Mar 17 '17, 4:09 p.m.
edited Mar 17 '17, 4:17 p.m.

Actually, It's easier than that Request.Category Name
......
Under Operational Data Store / Request Area / Request Category

You'll have do do a join between Request and Request Category.  Use Request.Category ID and Request Category.Request Category ID  columns.


Comments
Dave Griffin commented Mar 20 '17, 7:26 a.m.

Thanks for the quick response Kevin!

I'm new to RRDI and the query studio, and not sure how to do a Join. Can you please explain how to do that?

Dave 

Kevin Ramer commented Mar 20 '17, 8:30 a.m.

Well, I see Category Name on the Requests object in the Operational Data Store, so in this case you don't need a join.

There is a multi-part YouTube series on RRDI one of which is Using Joins


Dave Griffin commented Apr 21 '17, 2:02 p.m.

Kevin,

Thanks very much. That info gave me what I needed.

Dave

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.