It's all about the answers!

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

×42,882
×7,478
×496

question asked: Mar 19 '18, 4:30 p.m.
question was seen: 1,493 times
last updated: Mar 20 '18, 11:10 a.m.

Related questions

Can we include the creator id when building report in JRS?

0
Glenn N (11●1●16) | asked Mar 19 '18, 4:30 p.m.

Is it possible to add the creator id when building a report in JRS? I don't see it as available column

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kenji Sarai (960●3●9) | answered Mar 19 '18, 8:41 p.m.

Hi Glenny,

Firstly, when you are asking this kind of questions, please specify what data source (eg. data warehouse) and artifact type (eg. workitem) you are using. Otherwise it is impossible to give you a correct answer.

Assuming you are asking about RTC workitem in DWH, the answer is yes. RIDW.VW_REQUEST table has a column called Creator_ID. You need to add one line as below in Advanced section to modify SQL query.

SELECT DISTINCT T1.PROJECT_NAME,
       T1.REFERENCE_ID,
       T1.NAME AS URL1_title,
       T1.URL AS URL1,
       T1.CREATOR_NAME,
       T1.CREATOR_ID
FROM RIDW.VW_REQUEST T1
...
 

Comments
Glenn N commented Mar 20 '18, 10:34 a.m.

Hi

Thanks for your response.

Yes this is for RTC and data warehouse is the source. Looks like the creator ID is an internal id. I need to show the user id instead , is there a table where I can look this up? 

0
permanent link
Glenn N (11●1●16) | answered Mar 20 '18, 11:10 a.m.

Anyway I found the RESOURCE TABLE so this answers this

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.