Grid filtering datetime predicate does not work

Question

Hello,I updated package from 17.4.43 to 18.1.54. Filtering in grid has stopped working with datetime. I have created a working example on stackblitz. Has something changed or is this a bug?Thanks

Rajapandi Ravi · Answer

Hi ssvinciak, 

Greetings from syncfusion support 

Based on your code example we found that you have used the “greaterthanorequal” operator in grid query property and used the date value as “2020-05-26T18:29:00.803Z”. But in your service we found that there is no date values are greater than your mentioned date value in grid query. So, we suspect that it causes the no records to display.  

Please refer the below screenshot for more information. 

Screenshot: 

  
For your reference we have modify the date value in your sample and it works fine. Please refer the below code example sample and screenshot for more information. 

 





  const date = '1948-12-08T00:00:00Z'; 
   
    let grid: Grid = new Grid( 
        { 
            dataSource: data, 
            allowPaging: true, 
            query: new Query().where('BirthDate', 'greaterthanorequal', new Date(date)), 
            columns: [ 
                { field: 'BirthDate', type:'date', format: 'yMd', headerText: 'Birth',  textAlign: 'Right' }, 
            ], 
            pageSettings: { pageCount: 3 } 
        }); 
    grid.appendTo('#Grid'); 


Sample:  https://stackblitz.com/edit/pyhlcq-obv3tg?file=index.ts 

Screenshot: 

  
Regards,Rajapandi R

sbartos · Answer

Hello,Thanks for your reply. I forgot to mention that the variable date has to be a string because the filtering setting is saved in json. Therefore, I can't use new Date(...). It has worked before, but after the new upgrade, it has stopped. I have also tried other date formats such as '01/01/2020', but with no success.

Thiyagu Subramani · Answer

Hi ssvinciak, 

Thanks for your update. 

In your update you have mentioned that you cannot use new Date(...) option for value while generating query. 

So, we suggest you to use the query after column model created in grid. For this we suggested you to use created event to achieve your requirement. 

Please refer to the below code and sample. 





const date = '1948-12-08T00:00:00Z'; 
let grid: Grid = new Grid( 
  { 
. . . .  
    created: function (args) { 
        grid.query = new Query().where('BirthDate', 'greaterthanorequal', date) 
    }, 
  columns: [ 
    { field: 'BirthDate', type: 'date', format: 'yMd', headerText: 'Birth', textAlign: 'Right' }, 
  ], 
. . . . . . .  
grid.appendTo('#Grid'); 


Sample link : https://stackblitz.com/edit/pyhlcq-mkthbt?file=index.ts 

Reference link :  https://ej2.syncfusion.com/documentation/api/grid/#created 

In your update you also mentioned that it has been worked in previous version. So, we checked the attached sample with 17.4.43 version but still we face the same issue in the sample. 

Please get back to us, if you need any further assistance. 

Regards, 
Thiyagu S

sbartos · Answer

Hello,Thank You for your answer.The
 demo on the sample link you have provided does not filter at all. You 
can check it in the network console that the URL does not contain filter
 condition at all.I have tried to reproduce a working demo with 17.4.43, but I couldn't on stackblitz. Here is an example with fitersettings, which I have used before in older version. The problem is that it generates query like this:https://services.odata.org/V4/Northwind/Northwind.svc/Employees?$count=true&$skip=0&$top=12&$filter=(BirthDate ge '2020-01-01T00:00:00.00Z')And OData v4 handles it like a string because of the single quotes around the date. The right query should be like this:https://services.odata.org/V4/Northwind/Northwind.svc/Employees?$count=true&$skip=0&$top=12&$filter=(BirthDate ge 2020-01-01T00:00:00.00Z)So,
 can you implement check whether the value is in ISO date format in 
order to handle as a date, not as a string? Or can you provide another 
solution?

sbartos · Answer

Hello,I have updated the sample. It fails to build with 17.4.43. All settings are identical. If it would build, it might have been working with datetime query.The project has 2 branches. Please use the 17.4.43 branch.

Rajapandi Ravi · Answer

Hi ssvinciak, 

Sorry for the inconvenience 

After validating further with the source we have confirmed and logged this as a bug in the component. 

We have considered “Grid filtering predicate does not work in new version” as a defect and logged a report for the same. We will include the defect fix in our upcoming June 24, 2020 patch release. You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 

Feedback Link: https://www.syncfusion.com/feedback/14972/grid-filtering-predicate-does-not-work-in-new-version 

Regards, 
Rajapandi R

Rajapandi Ravi · Answer

Hi ssvinciak, 

We are glad to announce that our Essential JavaScript2 patch release (v 18.2.44) has been rolled out successfully. In this release we have fixed the reported issue “Grid filtering predicate does not work in new version” in our 18.2.44 release. So kindly upgrade to our package version (18.2.44) to resolve the reported issue.  

For your reference we have prepared a sample with our latest version (v 18.2.44). Please refer the below sample and screenshot for more information. 

Sample: https://stackblitz.com/edit/ujqof9-8vdxja?file=index.ts 

Screenshot: 
  

Feedback Link:  https://www.syncfusion.com/feedback/14972/grid-filtering-predicate-does-not-work-in-new-version 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 
Rajapandi R