Argthtjtr

I have a Jqgrid as follows:

 jQuery("#jQGridDemo").jqGrid({

            url: 'http://localhost:58404/JQGridHandler.ashx',

            colNames: ['Property ID', 'Property Ref', 'Short Address', 'Scheme Code', 'Scheme Name', 'Property Type', 'Tenure Type', 'Status', 'Management Cost','Rent Charge Month','SC Charge Month'],

            colModel: [

                        { name: 'PropertyID', index: 'PropertyID', width: 70, align: "left", stype: 'text', sortable: true},

                        {name: 'PropertyType',width: 80},

                        { name: 'TenureType', index: 'TenureType', width: 80, align: "center",  sortable: true },

                        { name: 'Status', index: 'Status', width: 75,  align: "center", sortable: true },

            ],

The grid works and is populated with the Json returned from the URL.
However, I am trying to implement a dynamically populated drop-down-filter on the PropertyType column and have been looking at Oleg's answer here: How to add dynamic filter drop down using Jqgrid?

I have therefore added a "beforeProcessing" function:

 beforeProcessing: function (data) {

                var propertyMap = {}, propertyValues = ":All", rows = data.rows, i, symbol;

                for (i = 0; i < rows.length; i++) {

                    symbol = rows[i].Symbol;

                    if (!propertyMap.hasOwnProperty(symbol)) {

                        propertyMap[symbol] = 1;

                        propertyValues += ";" + symbol + ":" + symbol;

                    }

                }

                $(this).jqGrid("setColProp", 'PropertyType', {

                    stype: "select",

                    searchoptions: {

                        value: propertyValues

                    }

                }).jqGrid('destroyFilterToolbar')

                    .jqGrid('filterToolbar', {

                        stringResult: true,

                        searchOnEnter: false,

                        defaultSearch: "cn"

                    });

            },

My question is, how do I pass the data returned from the URL to the "beforeProcessing: function (data)" -

Any help would be appreciated.

In case your data does not have a rows property you can modifiy your initial code like this:

 beforeProcessing: function (data) {

                var propertyMap = {}, propertyValues = ":All", rows = data, i, symbol;

                for (i = 0; i < rows.length; i++) {

                    symbol = rows[i].Symbol;

                    if (!propertyMap.hasOwnProperty(symbol)) {

                        propertyMap[symbol] = 1;

                        propertyValues += ";" + symbol + ":" + symbol;

                    }

                }

....

The only that differ from your original code is replacing

rows = data.rows

with

rows = data,