Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
670
WebDataGrid equivalent of old UltraGrid's ByNumericValue
posted

We have some data coming in that is stored as Text.  It needs to be sorted as its integer equivalent.  The issue is that the "strings" are like this "1", "2", "3", "10", "20", "50", "100".  Because these are "text" or strings when they come in, it sorts them like this: "1", "10", "100", "2", "20", "3", "50".  Using the old Ultra grid that we were using (very old), it had a Sort type of "ByNumericValue" that would actually treat the text as an integer and sort correctly.

Is there an equivalent in today's WebDataGrid? 

(We are using 11v1.2135)

Parents
  • 33839
    Verified Answer
    posted

    Hi greghendricks,

    The WebDataGrid sorts by the actual data type.  There are two options you could try.  The first would be to do custom data binding and then you sort the data treating the text as numbers.  Or you could make an unbound column that has these string values as an actual int and then sort the unbound column.

    regards,
    David Young 

Reply Children
No Data