Messages

1

Help for ParamQuery Grid (free version) / Dropdown list from JSON data

« on: January 25, 2016, 09:28:51 pm »

Hi,

I have successfully got my grid up and running using a "local" array of JSON data which I will then post back to my SQL server once changes have been confirmed.

I am now trying to implement a dropdown list in one of my columns (Branches) again using JSON data.

I have tried using the following function (and various iterations) in the "option:" section but so far have come up blank (quite literally).

Any assistance would be gratefully received:

Code: [Select]

               
var branchdata;

/* additional pqGrid code here */

{ title: "Branch", width: 100, dataType: "string", align: "left", dataIndx: "BRANCH_CODE", editor:{type: 'select', option: $.getJSON("/admin/lookups/branches", function (brjson) {
                        branchdata = brjson;})
                        }}];