jQuery Grid Plugin - jqGrid - Topic: Dynamic select options from server

koyyada on Dynamic select options from server

Fri, 17 Jul 2009 00:47:10 +0300

Hello,

You are given methodCall in url , is it method in url ,if so it is not working, can u help me plz.

sree

bujinwang on Dynamic select options from server

Fri, 26 Jun 2009 10:51:34 +0300

Thanks Sara. That resolved my problem.

Regards,

Burt

sarai on Dynamic select options from server

Thu, 25 Jun 2009 08:53:58 +0300

Hi Burt,

I just have the same problem, but I made a little trick to solve it, I don't know if there is another solution. By now I want to search my code with you.

I declare and input hidden and ther is where I put the values that I need in the select.

$(document).ready(function(){
     $.ajax({
        url:'tipomaquina.do?methodCall=getOptions',
        async : false,   //notice that async has to be false
        success: function(datos){
            $("#datos").val(datos);
        }
    });

    var idArea = $("#areas :selected").val();

    $("#table1").jqGrid({
        url:'tipomaquina.do?methodCall=fillTable&idArea='+idArea,
        datatype: 'xml',
        colNames:['Tipo de Maquina','Area'],
        colModel:[ {name:'tipoMaquina',index:'tipoMaquina', width:200, editable:true, edittype:'text',editrules:{required:true,size:30}},
                   {name:'area',index:'area', width:200, editable:true,edittype:'select',editoptions:{value:getOptions()},editrules:{required:true}}],
        rowNum:5,
        imgpath: gridimgpath,
        viewrecords: true,
        pager: $('#footer1'),
        caption:'Tipo de Máquina',
        editurl:'someurl'
    }).navGrid('#footer1',{edit:true,add:true,del:true,refresh:true,search:false,view:false},
                          {height:280,reloadAfterSubmit:true,top:130,left:500,url:'tipomaquina.do?methodCall=edit',closeAfterEdit:true},
                          {height:280,reloadAfterSubmit:true,top:130,left:500,url:'tipomaquina.do?methodCall=add'},
                          {height:150,reloadAfterSubmit:true,top:130,left:500,url:'tipomaquina.do?methodCall=delete'},
                          {});

    function getOptions(){
        return $("#datos").val();
    }

    $("#areas").change(function(){
        var idArea = $("#areas :selected").val();
        $("#table1").setGridParam({url:'tipomaquina.do?methodCall=fillTable&idArea=' + idArea,page:1}).trigger("reloadGrid");
   });
});

Hope this is useful to you. If there is someone that have another solution please let use know.

Thanks,

Sara

bujinwang on Dynamic select options from server

Wed, 24 Jun 2009 11:31:51 +0300

I have a column marked as "select" and I would like to dynamically specify the values from server. I have JSON/normal string ready from server.

I have tried to do ajax or $.JSON call, and the string is returned correctly as :

var locationData= ...get string from server;

and in colModal:

{
            name: 'locations',
            index: 'locations',
            width: 300,
            height: 800,
            editable: true,
            hidden: true,
            edittype: "select",
            editoptions: {
                multiple: true,
                value: locationData
            },
            editrules: {
                edithidden: true,
                required: true
            }
        }

it did not work! However if I specify the same string statically, it worked:

locationData = "1:loation1; 2:location2";

Burt