Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Replace by static value when NULL or Empty

miguelsilva
Kilo Contributor

Hello,

i ´m doing some database views and i ´m dealing with a request that i don't know how to do it...

The question is the following, Is possible to replace a NULL or Empty value from a field? Imagine the situation, the list of incidents sorted by group, BUT when the group is NULL or Empty i will like to display "Group not assigned" instead of appearing empty on the chart. Is this possible?

thanks in advance.

Miguel

3 REPLIES 3

manikorada
ServiceNow Employee

Thanks, i'am just researching further!


Hi @manikorada 

The provided link is not working for me can you please send the link again?

Or can you give a hint that it is possible to change empty to any custom string,

Thank you in advance