reports from sc_task table, not showing Catalog Variables data in report.

[Deepchand_Yadav]

reports from sc_task table, Started not showing Catalog Variables data in report. Earlier it used to show data and customers were using it to report.

When i have a deeper look into that , i found one workaround as flipped the Catalog Variables field "Global = True" and then refreshed the report underlying data in variables were started showing.

So wanted to check if this is known issue, or is there any other reason for sudden disappearing of variable data in report.

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Did you see my earlier response?

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[Dr Atul G- LNG]

Hi @Deepchand_Yadav 

Might be helpful

https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/use-service...

https://www.servicenow.com/community/platform-analytics-forum/how-to-report-a-set-of-catalog-task-sc...

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[Deepchand_Yadav · Accepted solution]

Thanks Robbie,

This solution i did as workaround. Global = True shows the data inside variable.

I am checking if any know issue happened which impacted reports showing data before.

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Did you see my earlier response?

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie