[Solved] Filtering problem with relation data

[Paweł]

Hello,

I'm using EntityDataSource with table User. I have also included table Transport related to User.
I have a column in my grid

<telerik:GridBoundColumn DataField="Transport.City" DataType="System.String" HeaderText="Transport" UniqueName="Transport" />

Filtering "IsEmpty" and "IsNull" and "NotIsNull" always return empty grig, while "NotIsEmpty" works perfect.
I guess it's because User can have Transport = null, and I'm binding column to Transport.City.

Please help, I realy need "IsEmpty" filter to work.

[Tsvetoslav]

Hi Paweł,

You are correct that in the case when Transport is null, the grid should return no data and this expected since the filter expressions you are setting tells the grid that City is empty, no that Transport  is null. Therefore, you need to intercept the ItemCommand event and in the cases in question modify your filter expression accordingly. I have demonstrated this in a small sample attached to this post.

Hope this information helps.

All the best,
Tsvetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Paweł]

And how to get this attachment?

[Tsvetoslav]

Hello Paweł,

Sorry for having left the attachment behind. I am attaching the files to this post.

All the best,
Tsvetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.