Hello everyone,
Can somebody help me understand if we can change the background of table widget where SQL query returns nothing.
Thanks,
Swapna M
I'm not understanding your question.
Do you mean that you created a dashboard/webpage, used the Widget and created a table or chart, added the table or chart to the page and the table or chart does not display information? Is that what you are going for?
Or, did you create an SQL/SWQL query for a custom table/chart and query doesn't give you the results you want/expect. Like a syntax error or logical programing error?
You got the background changing colour based on anything already? If so you could wrap the query up with a CASE WHEN x IS NULL THEN colour_y. Got this sort of thing working in proportional widgets and whatnot.
Similarly, this sort of method works ok in non-modern table widgets
So I have a table widget using SWQL that returns production nodes in the dashboard. The query works perfectly, but I am looking for change in background from default(screenshot below) when the query returns no data.