DataSource filtering not working

[Ollie]

I have this JSON that I am displaying in a kendo template. The format is as follows:

[
    {
        "Pending": [
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"}
        ],
        "Submitted": [
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue", "FieldB", "SomeValue"}
        ]
    }
]

 

It always return an array with 1 object that has 2 fields: Pending and Submitted. Now each field contains an array of objects shown above.

What I am trying to do is to filter Pending and Submitted thru Field A but its always nothing.

Here is my code:

var filtersArray = [
    {
        field: "Pending",
        operator: function(itemValue, value) {
            return itemValue && itemValue.find(function (item) {
                return item.FieldA == value;
            });
        },
        value: "searchTextHere"
    },
    {
        field: "Submitted",
        operator: function(itemValue, value) {
            return itemValue && itemValue.find(function (item) {
                return item.FieldA == value;
            });
        },
        value: "searchTextHere"
    }
];

var filter = {
    logic: "or",
    filters: filtersArray
};

formDataSource.filter(filter);

[Ollie]

Sorry, I accidentally hit the submit button and I can't find an Edit one.

My solution above always return/display nothing.

Anyways, i patterened my solution from here https://www.telerik.com/forums/filter-fields-from-nested-json-object

Thanks in advance!

Ollie dG.

 

[Ollie]

Correction again, the solution above always returns the original data and its not being filtered.

[Nikolay]

Hello Ollie,

The DataSource filtering works on the dataItem level. In the current case, we have only one data item:

{
      "Pending": [
              ...
       ],
      "Submitted": [
              ....
       ]
  },

And if we filter Pending.FieldA to match only "searchTextHere" dataSource.view() will return only the above dataItem as it passes the filter. However, if we have 2 dataItems and only one matches the filter criteria the filter will return only one dataItem:

• https://dojo.telerik.com/eyaCOgoJ

Let me know if you have any questions.

Regards,
Nikolay
Progress Telerik

[Ollie]

Hi Nikolay,

I understand now that it will return the whole dataItem that passed the filter, that is why when I was filtering, it always return the original data (because the dataItem passed the filter).

Is there anyway or anything that you can suggest to achieve what I am trying to do?

Given this

[
    {
        "Pending": [
            {"FieldA": "SomeValue1", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue2", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue3", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue4", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue5", "FieldB", "SomeValue"}
        ],
        "Submitted": [
            {"FieldA": "SomeValue1", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue2", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue3", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue4", "FieldB", "SomeValue"},
            {"FieldA": "SomeValue5", "FieldB", "SomeValue"}
        ]
    }
]

and If I filtered FieldA with "SomeValue3", the result will be

[
    {
        "Pending": [
            {"FieldA": "SomeValue3", "FieldB", "SomeValue"}
        ],
        "Submitted": [
            {"FieldA": "SomeValue3", "FieldB", "SomeValue"}
        ]
    }
]

Thanks!

 

[Nikolay]

Hi Ollie,

I am afraid, what you are trying to achieve is not possible with the built-in DataSorce functionality. The DataSource filters the data items and not the arrays that are set as properties to the data items.

I can suggest extracting the data of the data source, traverse it and get the data that matches the desired value.

Regards,
Nikolay
Progress Telerik