How to filter grid by cell content (dictionary text), not by model (dictionaty id)

[Vitaliy]

Hello,

 

I have a grid with a search box like the following:

Fiddle example

 

"Label" column contains a text so there are no any problem to filter grid with by this column. "statusId" column contains a dictionary element text, related to the identifier, kept in the statusId field of the model. So, when have "1" in the model, I see "Status1" in the grid cell

 

How could I filter grid by dictionary element text (so "2" in the filter box will show me rows, having "Status2" in the statusId column, and "Item2" in the label column?

[Boyan Dimitrov]

Hello Vitaliy,

The problem with the example that it expects an integer value for the statusId field. Please refer to the http://dojo.telerik.com/UWOYa example.

Regards,
Boyan Dimitrov
Telerik

 

 

[Vitaliy]

Hello Boyan,

Thank you for the answer, but your sample covers only particular case. The ​real need is to make a search by the cell visible content (i.e. by text of foreign key values). So, when I type Status1 I get all rows having in the statusName column text containing "Status1" (Status1, Status11, Status10, etc)

[Boyan Dimitrov]

Hello Vitaliy,

 

In general when ForeignKey column is used the value of the model field "statusId" in the DataSource is an integer. Operations such as sorting, filtering and etc are handled on DataSource level against the actual values ( the integer values for the "statusId" field). 

 

In order to implement filtering, sorting against the text value of the ForeignKey column custom code will be required. Please refer to the ForeignKey column sorting by text article that shows how to enable sorting by text in ForeignKey column using calculated field. Same pattern could be used for filtering as shown in http://dojo.telerik.com/AwINo example. 

 

 

 

Regards,
Boyan Dimitrov
Telerik