How to dot walk RITM variable in report

[JK9903]

Hello Everyone,

I want a report that shows the submitted catalog item details. In that catalog item, I have two reference variables user and group. I am able to get the variables in the report, but I want to dot-walk the reference to retrieve the email and display it in the report. However, I am unable to dot-walk the variable.

[Mark Manders · Accepted solution]

Your variable isn't an actual field, so you can't dotwalk there. You can add the 'email' as a hidden variable on the catalog item and have it auto filled (no scripting needed). Then you can just show the email variable as well on your report.

[Tanushree Maiti]

I second with @Mark Manders  . In report , on variable -you can not dot walk.

My recommended solution is same as Mark with taking hidden variable and store the variable as per your requirement. Use that hidden variable in your reporting.

[Ankur Bawiskar]

@JK9903 

You can't dot walk like that

you can try to create a database view joining 3 tables and your User and Group table then create report on that database view table

Then include the Email columns in report

See if that works

Report on Item Variables in the Service Catalog with a Database View 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏