Setting Variable Filter on Grid

[Perry]

What is the proper way of setting a filter on a datagrid from a variable?

I can manually set a filter in the parse function of the datasource but I assume there is a better way.

I've seen a post about setting the grid.datasource.filter  such as

        grid.dataSource.filter({field: "someValue", operator: "eq", value: someValue });

but when I put this in the databound event it does work but I'm getting some stack overflow errors so I assume this is wrong.

 

I've created a dojo showing what I have sofar.

Dojo

[Georgi]

Hi Perry,

Filtering the grid will actually rebind the grid, thus filtering the grid within the dataBound event handler will cause an endless loop.

If the requirement is to apply an initial filter to the dataSource, I would suggest you to use the dataSource.fitler configuration.

e.g.

var unitPrice = "10";
var viewModelIndex = new baseViewModel({

  dsPrices: new kendo.data.DataSource({
    data: [
      {
        unitPrice: "10"
      },
      {
        unitPrice: "18"
      },
      {
        unitPrice: "19"
      },
      {
        unitPrice: "21"
      },
    ],
    filter:{field: "unitPrice", operator: "eq", value:unitPrice },
  }),

});

Below you will find a modified version of the provided sample:

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

Regards,
Georgi
Progress Telerik

[Perry]

But in your updated dojo you are filtering the selection page......How would you apply the filter on the second page grid and datasource with the value from the selection page?   (e.g. Select price 10 and only see products with a price of 10)

[Georgi]

Hello Perry,

You could filter the second page grid before displaying the page itself.

e.g.

router.route("/productspage/unitPrice/:id", function (id) {
  viewModelproductspage.set("unitPrice", id);
  viewModelproductspage.products.filter({
      field: "UnitPrice",
      operator: "eq",
      value: id
    })
  layout.showIn("#content", productspage);
});

Below you will find a modified version of the sample:

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

Regards,
Georgi
Progress Telerik