Reporting on Affected CI table

[Hannah C]

Does anyone know how to get variables from a catalog task as columns on a report on the Affected CIs [task_ci] table?

When I dot walk from Task > Questions > search for the catalog item, select the catalog item variable - I am able to successfully see all of the variables in the selection and move them to the selected side. However, when I click "Run" on the report, the variable columns go back to un-selected.

[rahulpandey]

Hi, Please try using database views, you can basically join both task & task_ci tables together and even can have customized labels. Check this for starters https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/concept/c_DatabaseViews.html

[Mercedes Pons 1]

Hi, this post is from ages ago, but I'm facing this exact situation now.  I'm wondering if you found a solution.  Thank you