Filtering; sorting of filter options, and missing label filter option

[Derek]

(1) In a PivotGrid, is it possible to have the values sorted when filtering? If we display a list of values, from which to select, the values are unordered. If the number of values is lengthy, it's very cumbersome for the users to scroll through and find specific values since they have to look at every one.

Is it possible to have the list of potential values returned in sorted order?

(2) Why is it that the 'Label Filter' and 'Value Filter' only show up for certain columns? The user would like to use a substring search on one column, but the filtering options don't show anything other than the checkbox list.

[Kostadin]

Hi Derek,

As you could see at the following live example, which demonstrates the filter functionality, you could use the sort feature as well. Additional information could be found under Related Resources tab.


Regards,
Kostadin
Telerik

[Ryan]

Looking at the demo and the related resources, the sort order property simply controls how the value display in the Pivot Grid. However it does not control the Filter Window values. How can the values (labels) within the Filter Window be sorted?

[Kostadin]

Hi Ryan,

I am afraid that this could not be achieved out of the box. Nevertheless a possible solution is to manually find the ListBox control inside the Window. Please check out the following code snippet which demonstrates how to get the ListBox control.

<script type="text/javascript">

 

            function PivoGridCreated(sender, args) {

                if ($find("RadPivotGrid1").get_filterWindow() != null) {

 

                    sender.get_filterWindow().add_show(function () {

 

                        var filterWindow = $find("RadPivotGrid1").get_filterWindow().get_contentElement();

                        var listBox = $find(filterWindow.getElementsByClassName("RadListBox")[0].id);
                                 //sort the items manually

                    });

 

                }

            }

 

        </script>

After you have the RadListBox object you have to manually sort the items by rearrange them.

Regards,
Kostadin
Telerik