[JCR-2606] option to specify in query if empty values are sorted first or last

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.0
• Component/s: query
• Assignee: Unassigned
• Reporter: Torgeir Veimo
• Created: 14/Apr/10 13:39
• Updated: 14/Apr/10 13:39

Description

It would be of great value if there was a way to sort on a property, and specify wether nodes with empty / missing property values was put first or last in the resulting result.

In SQL, the standard syntax for this is:

order by ... [asc | desc] [nulls [first | last]] ,...