Sorting a table by a field that has an assigned domain results in certain records disappearing from the table.

Workaround

The Sort (Data Management) tool sorts the table using a field that is assigned a domain and maintains all records. Please note that the tool creates a new table in a file geodatabase with the sort's results.

Refer to this related documentation: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/sort.htm.

Steps to Reproduce