[NEW] Customize how to sort documents with `null` or missing fields

amyjian · 2024-12-19T16:50:10.731Z

In addition to specifying fields to sort on and the corresponding sort order, you can now specify how documents with missing or null values should be sorted in results using the noData option.

This allows you to sort ascending on a field foo while placing documents where foo: null or foo does not exist at the end of the results.

Read the docs
View Playground snapshot
Check out the examples

German_Medaglia · 2025-01-03T21:02:37.842Z

This is great! Is this available only for MongoDB 8?

amyjian · 2025-01-21T21:54:10.610Z

@German_Medaglia this is available on all versions of MongoDB.