[BUG] Sort columns says A-Z and Z-A for non-string fields

[brucejxz]

Describe the bug

When selecting a column in the "New Discover" experience in 2.13.0, the sort options for non-string fields are still:

• Sort A-Z
• Sort Z-A

To Reproduce Steps to reproduce the behavior:

1. Disable legacy discover
2. Add a non-string (int, datetime etc.) field to the table
3. Click on the field header

Expected behavior For datetime fields it would be a much nicer experience if the options were something like "Sort newest", "Sort oldest". And for number fields, perhaps something like "Sort largest" and "Sort smallest".

OpenSearch Version 2.13.0

Dashboards Version 2.13.0

Plugins

Reproducible at: https://playground.opensearch.org

Screenshots

Host/Environment (please complete the following information):

• OS: macOS 14.4
• Browser and version: Safari 17.4

Additional context

N/A

[abbyhu2000]

Confirmed the bug, for the new discover table, the sorting string say 'sort A-Z' or 'sort Z-A' for all the columns; for the legacy table, it says 'sort ascending' or 'sort descending'. The sorting functionality still works.

@opensearch-project/opensearch-ux what should we modify the sorting UI here for the new discover table?