Using SuiteQL, how can I get my response to includ...
# suiteanalytics
d
Using SuiteQL, how can I get my response to include null values. For example {SELECT manufacturer, mpn FROM item WHERE id ='123'} returns {mpn: "widget"}, instead of {manufacturer: "", mpn: "widget"} I have tried COALESCE(manufacturer, '') AS mfanufacturer, but no luck.