Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Replace by static value when NULL or Empty

miguelsilva
Kilo Contributor

‎03-23-2015 06:23 AM

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

Labels:
0 Helpfuls
  • 1,260 Views
3 REPLIES 3

manikorada
ServiceNow Employee
ServiceNow Employee

‎03-23-2015 08:37 AM

Silva,



Check this Custom Chart Data Generation - ServiceNow Wiki


0 Helpfuls

miguelsilva
Kilo Contributor
In response to manikorada

‎03-23-2015 10:59 AM

Thanks, i'am just researching further!


0 Helpfuls

Seraj
Tera Guru
In response to manikorada

‎09-08-2023 02:15 AM

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

0 Helpfuls