We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Unable to filter records, if there is any null value in first row of grid.

Thread ID:





144229 Apr 25,2019 04:21 PM UTC Apr 26,2019 09:29 AM UTC Angular - EJ 2 1
Tags: Grid
Asked On April 25, 2019 04:21 PM UTC

I am trying to filter records with existing filters.
Some properties are null from API data. in this case i am unable to filter records
Please see the below stackblitz link.

In the above provide example i am trying to apply filters for "Description" column.
But the first record contains null value for description.
So i am getting errors in console 
Please the below screenshot.

Hope you will respond ASAP.

Ebenezer Justin.

Hariharan J V [Syncfusion]
Replied On April 26, 2019 09:29 AM UTC

Hi Ebenezer, 

Thanks for contacting Syncfusion support. 

We have validated your query and the provided information. By default, If the column type is not defined, it will be determined from the first record of the dataSource. Incase if the first record of the dataSource is null/blank value for a column then it is necessary to define the type for that column.  

We suggest you to apply the column type as string for Description column in Grid. Please find the modified sample and documentation link for more information about column types. 

<ejs-grid [dataSource]='data' #sample [allowFiltering]="true" [allowSorting]="true" [filterSettings]="filterSettings"> 
        <e-column field="Description" headerText="Description" type='string'></e-column> 
        . . . . 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon