NULLS Last in filtered dataset pull

user11539
user11539 Member
in APIs & Domo Developer

I am using the dataset query API (https://api.domo.com/v1/datasets/query/execute/), and it is working fine except for one small sorting issue.

 

The SQL syntax supported by this API seems to support the "NULLS LAST" order by modifier, however, it seems to make no difference in the record ordering.

 

e.g., select FirstName, LastName, Address from table order by Address NULLS LAST

 

Is this not supported?

This discussion has been closed.

Categories