I need to only include the json field if there is a field other than blank
associated with that field's value...

for example, I set out trying to solve this by doing...

values
json_object(
case when :myVal <> ' '
then key 'myVal'
value trim(:myVal)
)

... but no go... compiler does not like this.

So on a field by field basis, how can I continue using the sql json
functions but condition which fields should be included in the json?

tia

Jay

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.