Sort Null Values First

Administrators use this system setting to specify whether to sort NULL values before other values (On) or after (Off). Select the value that matches your database. If this setting doesn't match your database setting, then the database setting takes precedence.

Valid Values

• On — Sorts NULL values before other values.
• Off — Sorts NULL values after other values. Default

Apply Required

Yes.

Change Effective

After a few minutes.

Edition

Professional and Enterprise.

API Key and Values

API Key — SortNullValuesFirst

API Values —

• YES
• NO

Documentation Links

• When Do System Settings Take Effect?
• Typical Workflow for Using System Setting REST APIs
• Examples for System Setting REST APIs