1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. Date filtering in grid

Date filtering in grid

Good morning.


I have a problem with a EJ2 datagrid, trying to create a filter on a datetimeoffset column, but the controller "thinks" its a datetime column and fails on the convertion.

this is my read method:

  public async Task<IActionResult> SyncFusionDbSet_Read<T>(DataManagerRequest dm) where T : class
        {
            IEnumerable<T> DataSource;
            DataSource = await _repository.FindAll<T>();
            DataOperations operation = new DataOperations();
            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = operation.PerformSearching(DataSource, dm.Search);  //Search 
            }
            int count = 0;
            if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting 
            {
                DataSource = operation.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering 
            {
                
                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
                count = DataSource.Cast<T>().Count();
             
            }
            else
            {
                count = DataSource.Cast<T>().Count();
            }
            if (dm.Skip != 0)
            {
                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging 
            }
            if (dm.Take != 0)
            {
                DataSource = operation.PerformTake(DataSource, dm.Take);
            }

            return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource);
        }

1 Reply 1 reply marked as answer
TS Thiyagu Subramani Syncfusion Team November 5, 2020 01:36 AM UTC

Hi Javier, 

Thanks for contacting Syncfusion forum. 

Based on your shared information we suspect that you want filter the datetimeoffset column. For this we have prepared a sample as per your requirement and tried to reproduce the reported problem at our end but unfortunately we are unable to reproduce the mentioned behavior at our end.  

In our grid we have used date object for that column in the dataSource and filtering one value for that date column is correctly sends query to the server. So we suggest you the way to achieve time zone conversion. Here we have used the ej.data.DataUtil.serverTimezoneOffset to convert time as per need. Please follow the below points to understand briefly,  

  1. By default, the time zone in server side is in UTC format. The grid component will automatically convert UTC to local time when rendered in grid UI.
  2. Here the serverTimeZoneOffest makes the time conversion in UTC level and displayed in grid.
  3. When you give the serverTimeZoneOffset value as “0” it shows the exact UTC time.
  4. The serverTimezoneOffset value may given based on the time zone value to be displayed on grid.
   
Please refer the below code example.  

<script> 
    ej.data.DataUtil.serverTimezoneOffset = 0;   // Here you can change the time as you need (add or minus the 5h30m )  
 
    . . . . . . . . .  
</script> 
 
Datasource we have used in the server
{  
order.Add(new OrdersDetails(code + 3, "ANTON",  1, 4.3 * i, true, new DateTime(2020, 10, 05, 20, 30, 20))); // we used date object in the server  
}  



If we misunderstood your requirement, please share the below details then only we provide the appropriate solution as soon as possible. 

1.  Explain your requirement briefly. 

2. Video/image representation of your requirement. 

3. Syncfusion package and NuGet package version. 

4.  If possible, share issue reproducing sample. 

Please get back to us, if you need any further assistance. 

Regards, 
Thiyagu S. 


Marked as answer
Loader.
Up arrow icon