Is this for the Plea Type column??
It actually should work, can you try to make sure there is null in any of the records to see how it is displayed, because the image you took is showing "Guilty" for each one of them.
No it’s the highlighted column headings that have Select lists on them.As you can see the null values are blank even with the attributes set to show a mask for nulls
1 person found this helpful
Sorry, my mistake... I missed the "GRID" part... that is why I was not sure why was not working.
Never done this on GRID, so I checked it out and investigated it... and yes, it is not, and I believe it should replace...
I also tried to add nvl(field, -1) and set the return value to -1 for the legend, and does not work.
It will only work, when value for returning is not null, and it is inside the select list options...
For example, in the query setting the nvl(field, -1) and then, in the select list values, including in th evalues "select 'choose something' as d, -1 as r from dual" (or whatever other way you would need to set it up); or just setting the filed
Problem is, that being a grid, you want to use the SAVE button, and want it to be saved as is. But that would imply that instead of a NULL you would get a -1 in the field.
So, basically, to your question, it is not possible (but maybe it should).
Either way, I think that if you MUST have this default message, you will need to save the GRID using a PL/SQL rather than letting the GRID do it automatically, this way you can control those fields and if they are still having a "-1" set them to still be null in your database table, and for that I suggest you refer to: APEX 5.1 How to manually process Interactive Grid data using PL/SQL
I hope this somewhat helped you.
Thanks for you help and tests Jorgelina