1. Feedback
  2. jQuery
  3. 22108

Welcome to the jQuery feedback portal. We’re happy you’re here! If you have feedback on how to improve the jQuery, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes

Search not working for fields with foreign key mapping--Object null in ej.web.all.js

Hi

If you check the javascript file: https://cdn.syncfusion.com/18.3.0.47/js/web/ej.web.all.js


And scroll down to line no:127239 , where its checking for the value column.filterType, the object column isn't defined, its null & hence the search doesnt work for foreign key fields



if (!firstLoop) {

                            var dataManger = ej.DataManager(this.model.filterSettings.filteredColumns);

                            var query = new ej.Query().where("field", ej.FilterOperators.equal, filterObject.field);

                            var object = [];


The below if condition is the culprit which wasnt present in older versions 15.3.**

if((!ej.isNullOrUndefined(column.filterType) && column.filterType != 'excel') || (ej.isNullOrUndefined(column.filterType) && this.model.filterSettings.filterType != "excel") || filterObject.value == "")

object = dataManger.executeLocal(query);

                            for (var j = 0; j < object.length; j++) {

                                var objectIndex = $.inArray(object[j], this.model.filterSettings.filteredColumns)

                                if (objectIndex != -1)

                                    this.model.filterSettings.filteredColumns.splice(objectIndex, 1);

                            }