Is possible to add catalog item variables as columns when reporting on TASK table?

[sicad_]

Hello,

We have a request to create a report on the TASK table to get some RITMs and Incidents. For RITMs created for some catalog items we need to add some catalog item variables as columns. Is there any possibility to add these variables directly from the task tables?

Reporing on RITM table,  the Variables field is available and we can add the catalog items variables as columns on our report. Reporting on TASK table, the Variables field is not available for reporting.

Please find in the attachment the report on RITM table and see the Variables field available. After choosing the Catalog Item name, a list of all the variables of the Catalog Item are available and each variable can be added to the report as column. We need to achieve this but on the TASK table.

If I'm looking to the TASK table definition, the Variables column is available but when trying to report on TASk table this Variables field is not available.

Tried to create a database between TASK and RITM table to bring the Variables column from the RITM table but again the Variables column not available for reports.

Thank you in advance!

Regards,

Sica

[Ankur Bawiskar]

Hi Sica,

variables and their values are stored in this table sc_item_option_mtom, sc_item_option

you can try creating database view and join those 3 tables I guess; sc_task, sc_req_item and sc_item_option_mtom,sc_item_option

for reference screenshots below:

you can use u_task_ritm_variables as table in the reporting

1) Task table view fields:

2) RITM view fields

3) Item Option view fields

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

[Gabriel3]

I did this in:

https://community.servicenow.com/community?id=community_question&sys_id=7690321ddb031814d5c4d9d96896...