Need to able to filter on concatenated values columns in grid

[Deepika]

Hi,

I have requirement where I have grid with columns which is combined values of two fields from a object array.

Example: I have a array of object with Code, Description, Id. and I'm displaying both Code and description in the grid columns.

but in Filter I'm only able to filter based on the description not the Code and description concatenated value. 

How can we achieve it?

Thanks,

Deepika.P

[Rajapandiyan Settu]

Hi Deepika, 

  

Greetings from Syncfusion support. 

 

Query: I have an array of objects with Code, Description, Id. and I'm displaying both Code and description in the grid columns. But in Filter, I'm only able to filter based on the description, not the Code and description concatenated value.  

How can we achieve it? 

 

In EJ2 Grid, all the Grid actions like Filtering, Searching, Sorting, Grouping, etc., are based on the column field name only. This is our behavior of EJ2 Grid. 

 

We can concatenate any value in the column by using the valueAccessor/columnTemplate feature. But this is used only for display purposes. We cannot perform Grid actions like Filtering, Searching, etc., to that concatenated value. 

 

Regards, 

Rajapandiyan S