Sunday, March 24, 2019

Convert -None- to Blank on Saved Searches Result

The ability to display –None- on Saved Searches as blank is currently filed as Enhancement# 177224. If a customer wants to replace –None- on the results of a Saved Search, the function NVL(expr1, expr2) can be used. The NVL() function uses expr2 if the value of expr1 is null.


For example, if some name fields on the Saved Search shows as –None- then users can use this field instead of Name in the Results tab:


Formula(Text) = NVL({name}, ' ')

No comments:

Post a Comment