How to set min value for Kendo web grid numeric field filter?

[Vihang]

Hi,

I am using KendoUi web grid with MVC. I have a integer column. I need to prevent user to enter negative values in the filters from the numericdropdown.

Please guide me how can I achieve this?

Please refer attached image for clear idea what I want to do.

[Jayesh Goyani]

Hello,

<link href="http://cdn.kendostatic.com/2013.1.319/styles/kendo.common.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2013.1.319/styles/kendo.default.min.css" rel="stylesheet" />
    <script src="http://cdn.kendostatic.com/2013.1.319/js/kendo.all.min.js"></script>

<div id="grid">

</div>

<script type="text/javascript">

    $(document).ready(function () {

        $("#grid").kendoGrid({

            dataSource: {

                type: "odata",

                transport: {

                    read: "http://demos.kendoui.com/service/Northwind.svc/Orders"

                },

                schema: {

                    model: {

                        fields: {

                            OrderID: { type: "number" },

                            Freight: { type: "number" },

                            ShipName: { type: "string" },

                            OrderDate: { type: "date" },

                            ShipCity: { type: "string" }

                        }

                    }

                },

                pageSize: 20,

                serverPaging: true,

                serverFiltering: true,

                serverSorting: true

            },

            height: 430,

            filterable: true,

            filterMenuInit: function (e) {

                if (e.field == "Freight") {

                    $(e.container.find("input:eq(1)")).kendoNumericTextBox({

                        min: 0

                    });
                    $(e.container.find("input:eq(3)")).kendoNumericTextBox({


                        min: 0


                    });


                }

            },

            sortable: true,

            pageable: true,

            columns: [{

                field: "OrderID",

                filterable: false

            },

                            "Freight",

                            {

                                field: "OrderDate",

                                title: "Order Date",

                                width: 120,

                                format: "{0:MM/dd/yyyy}"

                            }, {

                                field: "ShipName",

                                title: "Ship Name",

                                width: 260

                            }, {

                                field: "ShipCity",

                                title: "Ship City",

                                width: 150

                            }

                        ]

        });

    });

 

</script>

Please also check below link for reference.

http://docs.kendoui.com/api/web/grid#events-filterMenuInit

If you this code gives any error related to "filterMenuInit" event then please update your Kendo UI Version.

Thanks,
Jayesh Goyani