Currently, there is no way to customize the output of a null property in Ontology Manager or Workshop. Null values always appear as ‘No Value’. The documentation states to create a function backed property/column, which is a solution, but not great (https://burnsmcd.palantirfoundry.com/docs/foundry/questions-answers/workshop#how-can-i-display-a-static-string-like-no-date-specified-in-a-table-in-workshop-when-the-date-property-is-null)
I would like to be able to customize how null properties appear in the Ontology Manager similar to the formatting options on the Display tab of the property.
For the most part, this isn’t a huge problem. However, when I want to send an object set to a Notepad and use a table generator for a report export, having all the ‘No Value’ strings can be a pain to deal with.
Yes, that is one option that we have used, butI still see it as sort of a ‘workaround’.
In my current, case, I am dealing with Dates. Ideally, I want a blank cell. So even if I create a string column in PB and make logic to handle the null, the best thing I can do is make it ‘-’ or something more discrete. This would also impact some of the workshop functionality with dates that is needed.
My plan is: anywhere where the ‘No Value’ is an issue for users (mainly the Notepad export I mentioned), I will use a code function to create a new, string column that does the date-string conversion and use ‘-’ or single space string
Update: There is a null value configuration in the Row Generator of Notepad that solves my particular problem. However, it would still be nice to have a similar feature in Ontology Manager.