Notes/Domino XPages Development Forum - how to correctly sort a date column in an enhanced data grid?

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

~Denise Elhipilyoopsi

Jun 1, 2018, 5:01 PM

68 Posts

how to correctly sort a date column in an enhanced data grid?

Category: Debugging
Platform: Windows
Release: 8.5.3
Role: Developer
Tags: dojo datagrid sort date column
Replies: 0

I have an enhanced data grid, using a REST service to populate it from a view. It works great! I love the flexibility of the grid. BUT my users would like to be able to sort date columns.

In order to get the column to even display in the data grid, I have to @Text the value (so it doesn't look like 2011-12-01T17:00:00Z). And when we sort on a text value, it's not the same as sorting a date value. Is there a way to sort these columns (correctly)?