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

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
...
 

Anyway I found the RESOURCE TABLE so this answers this