I am being asked to use a database that is full of [BLANK] and NULL values in the same column. So if I want to insert an App Connect Binding with a Ternary Operation (if/else) and want “if [BLANK] or NULL put nothing else put value” do I always have to put this as the expression?
Server-side you should be able to do something like old_code.default('')
But client-side blank (not null) doesn't trigger the default so you would need the ternary there: