Nitrite/Java: Any way to sort by several fields?

[Doc1faux]

Hello,

Assuming the "Customers" demo database here, I would like to order by "Country" then "City" columns as in the "ORDER BY Several Columns Example".

Unfortunately, neither in the documentation nor diving into code, I found any method to do so with the Cursor<T> find(ObjectFilter filter, FindOptions options) method.

Like ObjectFilter and(ObjectFilter... filters), I was expecting a method to give several fields to sort by or a FindOptions thenSort(String field, SortOrder sortOrder) method to chain sorting.

If not, I assume it should be achieve by our own implementation?

[anidotnet]

Currently sort by multiple fields is not supported in nitrite 3.x. You need to get the List<T> from Cursor<T> and perform the sorting on the list in application side.

Having said that, in version 4.x, I am introducing support for sort by multiple fields which can take advantage of compound index if available. Stay tuned.