The SQL fragment to order by, which can reference selected fields. Example: COALESCE(NULLIF(display_name, ''), split_part(full_name, '/', 2)). May not contain ASC or DESC, as ordering direction is controlled by the order property.
COALESCE(NULLIF(display_name, ''), split_part(full_name, '/', 2))
order
The SQL fragment to order by, which can reference selected fields. Example:
COALESCE(NULLIF(display_name, ''), split_part(full_name, '/', 2)). May not contain ASC or DESC, as ordering direction is controlled by theorderproperty.