sort multi filter checkbox values

[sandy]

Hi ,
i want to sort values in multi checkbox filter dropdown.
here am attaching image and project code . pls find it.

 

https://drive.google.com/file/d/1BigmLzF_12b2sFzANGrGWCWaA5j4gcBT/view?usp=sharing

[Nikolay]

Hello Sandy,

Thank you for sharing the project with me.

Since the Grid DataSource does not use server operations (.ServerOperation(false)) the approach demonstrated in the below forum post can be used:

• https://www.telerik.com/forums/column-menu---sort-multiple-checkbox-filter#hSiC9WNW7U6rKDz2JleZtQ

Please try it and let me know if you have any questions

Regards,
Nikolay
Progress Telerik

[sandy]

Hi Nikolay,

if i use FilterMenuInit then aggrigate functions are not working properly while applying filters in pageload.

[Nikolay]

Hello Sandy,

I have replied to another forum thread of yours discussing the same topic:

• https://www.telerik.com/forums/how-to-get-multi-filtered-values-in-javascript#sO3mjjArOEeYXCNWuXVFeQ

Please let me know if this helps. In case I am missing something please share more details.

As a side note, I suggest we continue the communication in a single thread, eighter here or in the above-mentioned one. As per our terms of use, different threads shall be submitted only for different inquiries.

Regards,
Nikolay
Progress Telerik

[sandy]

Hi Nikolay,

That given link solution is different to this thread. so anyway i opened another thread with complete details and attached project.

[Nikolay]

Hello Sandy,

I have replied to another thread of yours duplicate tho this one. Let's keep the communication there:

• https://www.telerik.com/forums/sorting-values-inside-multi-filter-checkbox

Kind regards,
Nikolay
Progress Telerik

[sandy]

Hi Nikolay,

here is my solution to my question. here am posting bcs it will useful to anybody.

 

in filterMenuInit function first am retrieving checked values in multi checkbox container. after getting checked values am storing in some variable. after am sorting values in multi checkbox container. after sorting values then am doing check box checked activity using datasource filter method. below is my code.

 

function filterMenuInit(e) {
        var FilterdValues = getGridFilterValues();
        if (e.field === "ProjectName.ProjectName" || e.field === "Dept.DeptName" ) {
            var title;
            if (e.field === "ProjectName.ProjectName") {
                title = "Project Name";
            }
            else if (e.field === "Dept.DeptName") {
                title = "Dept CC";
            }
           

            var filterMultiCheck = this.thead.find("[data-title='" + title + "']").data("kendoFilterMultiCheck")
            filterMultiCheck.container.empty();
            filterMultiCheck.checkSource.sort({ field: e.field, dir: "asc" });

            filterMultiCheck.checkSource.data(filterMultiCheck.checkSource.view().toJSON());
            filterMultiCheck.createCheckBoxes();
            //applyMyFilters();
        }
        if (FilterdValues.length > 0) {
            var filters = FilterdValues.split(',');
            var firstField = filters[0];
            var secondField = "";
            var thirdField = "";
            var fourthField = "";
            var fifthField = "";
            if (firstField != null && firstField != "") {
                var dataSource = $("#Grid").data("kendoGrid").dataSource;
                var _fltMain = [];
                var _fltParent = { logic: "and", filters: [] };
                var _flt = { logic: "or", filters: [] };
                var _fltSecond = { logic: "or", filters: [] };
                var _fltThird = { logic: "or", filters: [] };
                var _fltFourth = { logic: "or", filters: [] };
                var _fltFifth = { logic: "or", filters: [] };
                var bool = false;
                for (var i = 0; i < filters.length; i++) {
                    var filtercount = filters.length - 1;
                    if ((i % 3) == 0 && i < filtercount) {
                        if (filters[i] == firstField) {
                            _flt.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                        }
                        else {
                            if (bool == false) {
                                _fltParent.filters.push(_flt);
                                bool = true;
                            }
                            if (secondField == "") {
                                secondField = filters[i];
                            }
                            else if (thirdField == "") {
                                thirdField = filters[i];
                            }
                            else if (fourthField == "") {
                                fourthField = filters[i];
                            }
                            else if (fifthField == "") {
                                fifthField = filters[i];
                            }
                            if (secondField == filters[i]) {
                                _fltSecond.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                                thirdField = "";
                                fourthField = "";
                                fifthField = "";
                            }
                            else if (thirdField == filters[i]) {
                                //_fltParent.filters.push(_fltsecond);
                                //thirdField = filters[i];
                                _fltThird.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                                fourthField = "";
                                fifthField = "";
                            }
                            else if (fourthField == filters[i]) {
                                _fltFourth.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                                fifthField = "";
                            }
                            else if (fifthField == filters[i]) {
                                _fltFifth.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                            }
                            else {

                                _fltParent.filters.push({ field: filters[i], operator: filters[i + 1], value: filters[i + 2] });
                            }
                        }
                    }
                }
                if (_fltSecond.filters.length > 0) {
                    _fltParent.filters.push(_fltSecond);
                }
                if (_fltThird.filters.length > 0) {
                    _fltParent.filters.push(_fltThird);
                }
                if (_fltFourth.filters.length > 0) {
                    _fltParent.filters.push(_fltFourth);
                }
                if (_fltFifth.filters.length > 0) {
                    _fltParent.filters.push(_fltFifth);
                }
                if (_fltParent.filters.length > 0) {
                    _fltMain.push(_fltParent);
                }
                else {
                    _fltMain.push(_flt);
                }
                dataSource.filter(_fltMain);
            }
        }
    }

 

 

 

function getGridFilterValues() {
        var dataSource = $("#Grid").data("kendoGrid").dataSource;
        var filter = dataSource.filter();
        let FilterdValues = [];
        $.each(filter, function (i, filters1) {
            if (filters1 != "and" && filters1 != "or") {
                $.each(filters1, function (j, filters2) {
                    if (filters2.field != "" && filters2.logic != "and" && filters2.logic != "or") {
                        FilterdValues += [filters2.field, filters2.operator, filters2.value, ""];
                    }
                    else {
                        $.each(filters2, function (k, filters3) {
                            if (filters3 != "and" && filters3 != "or") {
                                $.each(filters3, function (l, filters4) {
                                    if (filters4.field != "" && filters4.logic != "and" && filters4.logic != "or") {
                                        FilterdValues += [filters4.field, filters4.operator, filters4.value, ""];
                                    }
                                    else {
                                        $.each(filters4, function (m, filters5) {
                                            if (filters5 != "or" && filters5.logic != "and") {
                                                for (x = 0; x < filters5.length; x++) {
                                                    if (filters5[x].field != "") {
                                                        FilterdValues += [filters5[x].field, filters5[x].operator, filters5[x].value, ""];
                                                    }
                                                }

                                            }
                                        });
                                    }
                                });
                            }
                        });
                    }
                });
            }
        });
        return FilterdValues;
    }