I have a scenario where I need to display a list of items under a column for an entry. I have attached an example illustrating this scenario (3rd Column in the table).
I want to be able to apply filters on that column, but obviously just enabling the filters on the grid is not working. When I apply a filter on that column, I want to see the filter applied to the list and show the results in the table.
I have the same issue with sorting too. Nothing happens when I click on the header for that column. I want to sort within each individual list when I click on the header.
Is there a better way to display the data in a similar way in the grid without having to embed lists? Or if this is a good way to go about it, how can I accomplish the above-mentioned operations?
Hello Viswanath,
Thank you for your reply. Filtering is done on the cell values and will not adhere to the additional items you have in your list automatically the way you currently in your current implementation. If you wish to populate the drop-down items with specific items related to the items displayed within each list of each cell in your column in question then you'll need to provide custom filter items.
You can begin by setting the FilterEvaluationMode enum property on the XamDataGrid to Manual.
eg.
You'll also need to handle the XamDataGrid's RecordFilterDropDownPopulating event and implement your own manual filtering logic.
There is a sample demonstrating this on our website (which is accessible in our sample's browser application)
http://ko.infragistics.com/samples/wpf/data-grid/custom-filter-drop-down-items
We also have a blog posting about this functionality here:
http://ko.infragistics.com/community/blogs/damyan_petev/archive/2012/05/07/external-sorting-grouping-filtering-aggregation-with-the-wpf-xamdatagrid.aspx
Let me know if you have any questions regarding this matter.
Hi Michael,
I think you understood my requirement in a different way than what I meant it to be.
I want to be able to filter on the data in the lists. Like, if I type List "Item0-0", I want to see all the rows which have lists that have "Item0-0".
Viswanath,
Thank you for following up. I ran your sample and experienced the same issue. I believe its due from the fact that you aren't adding your binding in xaml.
I updated line 23 in your sample with the following binding and I am now able to filter on the items. (before they weren't showing up in the dropdown).
<igDP:UnboundField Binding="{Binding Converter={StaticResource Conv},ConverterParameter=Values}" Label="Values">
It will require some formatting but this should help you get started.
Let me know if you have any questions.