Database view showing (empty) on fields with data while returning other fields from same record

[smacleod]

I have a database view set up to link the SLAs to the RITMs to the Tasks so we can review information on that basis.

I have a database view that is working for our visualizations, however upon reviewing the list it is only returning (empty) for the catalog task numbers while returning other valid information for those tasks (assignment groups, assigned to, etc.). What can I do to make sure all the catalog task information shows up reliably.

[Vishal Jaswal · Accepted solution]

Hello @smacleod 

Please avoid using uppercase in the variable prefix as per this KB article here: KB0727206 

[smacleod]

thank you, this solved my issue

[Vishal Jaswal]

Glad to hear that @smacleod 

I have submitted an idea to ServiceNow, please vote so that ServiceNow takes care of it and subscribe to get any updates on this idea here: https://support.servicenow.com/ideas?id=view_idea&sysparm_idea_id=b2af31cf935ccbd8e7eef35d6cba1097&s...