Mapping a null value to a constant in a list column?

Classic Servoy
1

Hi,

I’m new to Servoy, so pardon what’s likely a simple question.

I have a list form displaying data from a table. One column in the list is being brought in from another table via a join. The data value in that column, as found in the database is either present or null. When displayed in the list, I’d like to map/format a constant value whenever the column value is null (i.e. null —> “SomeValue”). However, I can’t seem to discover where/how to do this. I tried using the format property, which almost works. However, the null values display as empty in the list unless I click on one of the cells, and then the formatted value shows up for that cell. If I were writing the SQL directly, I could populate the value in the select list. Is there a hook/event where I can programmatically set this value?

We are running Servoy Developer 5.2.2.

2

If you don’t need the users to be able to sort the data on that column you could create a calculations like this:

if(yourColumn)
{
  return yourColumn;
}
else return 'Warning! The column is NULL!';

and just display the calculation instead of the column.