Grid : load Filter with zero does not work

Hi Team,

Scenario : I am trying to filter gird  before loading . however it does not work with column having value  0.

but when we  apply filter to that column  and  try to filter with 0 it work's fine .

Below is the code:

this.filterOptions = {columns: [{ field: 'TOTALQUANTITYEXCEPTIONS', matchCase: false, operator: 'startswith', predicate: 'and', value: 0}]};



1 Reply

BS Balaji Sekar Syncfusion Team November 29, 2021 07:51 AM UTC

Hi Tanveer, 

Greetings from the Syncfusion support. 

Query: I am trying to filter gird  before loading . however it does not work with column having value  0. 

We checked your query with provided the information and you have filtered the number column with “startswith” operator which is an invalid operator of Number column. It is cause of the reported problem. Since we shared the details about required operators to column’s type basis. 
 

Since we suggest you to use “equal” operator instead of “startswith” and you can overcome the reported problem. We shared a sample with your requirement as given below. 


Regards, 
Balaji Sekar.  


Loader.
Up arrow icon