Populate select list from DB

[paramvir]

Sounds great!

[queensgambit9]

Was a bit quick there...
Still having issues with the format of the json response. Currently I have:

Code: [Select]

{ {"country": [{"country":"aaa"}, {"country":"bbb"}]}, {"city": [{"city":"ccc"}, {"city":"ddd"}]} }
Won't work...guess format is wrong?

Also, how can I use a variable when assigning the options like:

Code: [Select]

arrCol.forEach(function (value) {
  column = grid.getColumn({ dataIndx: value });
  column.filter.cache = null;
  column.filter.options = response.[_USE_VARIABLE_VALUE_];
});

[paramvir]

Please remove extra {}

Response could be:

Code: [Select]

{
    "country": [{"country":"aaa"}, {"country":"bbb"}], 
    "city": [{"city":"ccc"}, {"city":"ddd"}]     
}

Since response is an object, so use for loop:

Code: [Select]

for(var key in response){
  grid.getColumn({ dataIndx: key }).filter.options = response[ key ];
}


[queensgambit9]

Thanks. Adjusted JSON response, but still can't get it to work...

Code: [Select]

var arrCol = ["col1", "col2"];
    var grid = this;
    $.getJSON("/php/data.php", "cols=" + JSON.stringify(arrCol), function (response) {
        // all keys looks correct in response           
        for(var key in response){
            grid.getColumn({ dataIndx: key }).filter.options = response[ key ];
        }
       
        grid.refreshHeader();
    });

[paramvir]

Did you check for any error in the browser console and did you use a debugger inside the for loop to ensure every filter.options are assigned correctly.

Could you share json response in an attachment file.

[queensgambit9]

No error in console. The options are assigned when I check the filter options using the debugger in console.
But the options do not appear.
Response is attached.

[queensgambit9]

Update: Seems to be working now, didn't have the

Code: [Select]

column.filter.cache = null;...
Thanks for your help.

[paramvir]

Oh ok, that means you are using older version <= 5.1.0.

cache null is not required in >= 5.2.0

[queensgambit9]

You are correct, was using 5.1.0.