Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Variables data is missing after exporting to excel.

InnamuriH
Tera Contributor

We created a report on sc_task table and added few columns those are the variables in the ritm and not visible on the task, in the report in back end I can see the data but after extracting to Excel the data for those variable columns are showing as empty.

 

So I thought of creating the report on RITM table but the end user requirement is to get the task number then I thought of creating a database view. with that when I am adding columns related to variables after saving again the variables in the columns are missing?

 

Any right approach any one can suggest.

1 REPLY 1

Ankur Bawiskar
Tera Patron

@InnamuriH 

looks like a known issue

Exporting Catalog Variables - Support and Troubleshooting

Variable columns do not show on List Report when selected table is a Database View - Known Error

is it visible to admin?

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

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