Adding catalog item variables into report?

sndev1099
Giga Expert

Hi, 

I need to add the below variable into the below table for a particular catalog item but it isn't available to dot walk to. Is there another way I can achieve this? Do I need to create a DB view and if so, what tables?

sc_req_item:

find_real_file.png

 

Need this variable to display:

find_real_file.png

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

If it's a report then I was able to add this in my PDI; Orlando release

It's not possible to add variables on RITM Table List View

1) create report on sc_req_item table

2) in filter condition; select Item as your catalog item

3) in the available section; click on Variables & click + icon; it will ask you the catalog item; select your catalog item

4) now it shows whatever variables belongs to that catalog item

5) now move variables you want from available to selected; I have selected all 5 variables under that catalog item

find_real_file.png

find_real_file.png

find_real_file.png

find_real_file.png

find_real_file.png

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

9 REPLIES 9

How did you navigate to this page? Your answer sounds like it should address my question, but I can't get the "variables" to show up in my "Create a report" UI. Do you know how to do this using Tokyo? My screenshot does not show "variables" as a selectable item.

snow2p_0-1695247156578.png

 

Hi @Ankur Bawiskar 

currently i working on Utah version, i have the same requirement about the catalog variable into report, the report is about combine the catalog item variable with the asset. We can get which request, number etc.. along with the assets status.

 

Ihave following your guidance until point 5 after move the variables and save the report, then the variable are missing and left the box empty, kindly share the workaround. Thanks!

@Asep 

Can you post a new question for this as this is an older thread? tag me there

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 

Thanks!

 

i have created new post, have you receive the notification?
or you can direct using this link

https://www.servicenow.com/community/sam-forum/adding-catalog-item-variables-into-asset-report-utah-...

Hi Ankur

If variable have one reference variable doe ex: primary owner it's user reference table.

Then how to get the column of primary owner of contact number dynamically in report.