• Replies 1 reply
  • Subscribers 40 subscribers
  • Views 439 views
  • Users 0 members are here
Options
Related

Is it possible to sort only by date and not time for "short_date_time" type of column

Fozia Khan
Offline

Hello,

Please confirm is it possible to have this the sorting specification of the search grid.
If a date type property is specified as a sort key, is it possible to switch sorting by pattern?
(1) When the pattern is "short_date_time", sorting including hours, minutes and seconds (as per current specifications).
(ii) When the pattern is "short_date", sort ignoring hours, minutes and seconds.

Thanks

Fozia

  • Hi,

    the sort pattern specified in the ItemType is mainly used for displaying the data and doesn´t influence the actual get query to the server (to my knowledge).

    I don´t think what you want to achieve is possible out of the box. But there might be a few options:

    One option is to use a custom "Simple" Search Mode for the grid. You could overwrite the conversion from the AML request to the SQL query. So basically you change how the search grid handles dates. But this one wouldn´t be my preferred solution, cause it´s not very transparent for the end user.

    Out of interest: Why is do you need the strict date sorting that ignores the time? What is your use case? And aren´t you an Aras employee? :D

    Best regards!

    Angela