Scheduler OdataV4 date filters are not filtering data

Hi Great Support;

I have simple scheduler like in here;
https://blazor.syncfusion.com/documentation/scheduler/data-binding/#using-odatav4adaptor

 when i am switching next and previous weeks 

On fiddler i noticed that queryes are not building correctly like these;

 /odata/DerslikRezervs?StartDate=26.09.2020%2021:00:00&EndDate=3.10.2020%2021:00:00

 /odata/DerslikRezervs?StartDate=3.10.2020%2021:00:00&EndDate=10.10.2020%2021:00:00

it has to have some "greatherthen" "smallerthen" operators. Am i wrong?
/odata/DerslikRezervs?filter=(StartTime ge 2020-09-29T00:00:00.000Z) and (EndTime le 2019-11-16T00:00:00.000Z)

Thanks

1 Reply 1 reply marked as answer

AK Alagumeena Kalaiselvan Syncfusion Team October 6, 2020 02:09 PM UTC

Dear Customer, 

Greetings from Syncfusion support! 

We have checked your reported issue “In OdataV4 date filters are not filtering data” followed by our documentation but unfortunately we could not replicate your issue at our end. We have prepared a sample based on your requirement which can be get by the following link. 

Steps to run above sample : 
  1. Ensure the both projects must be in running state. To do this, just right click on the solution(in VS) and select the set Startup Projects and in the setting window, choose the Multiple Startup Projects option and both project's actions must be in start action. please refer the below  
  2. Need to change the DB connection string in the ScheduleDataContext.cs file. As like below code 
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) 
        { 
            if (!optionsBuilder.IsConfigured) 
            { 
                optionsBuilder.UseSqlServer("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=D:\\blazor_incident_samples\\F158374\\odata\\odata\\Restful_Services\\App_Data\\ScheduleData.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework;Integrated Security=True"); 
            } 
        } 
... 

Please try with shared sample and let us know, if this issue still persist. 

Regards 
Alagumeena.K 


Marked as answer
Loader.
Up arrow icon