jQuery Grid Plugin - jqGrid - Topic: searchOptions.searchField = "Undefined" http://www.trirand.com/blog/?page_id=393/help/searchoptions-searchfield-undefined Simple:Press Version 5.7.5.3 Vee on searchOptions.searchField = "Undefined" http://www.trirand.com/blog/?page_id=393/help/searchoptions-searchfield-undefined#p25577 Help http://www.trirand.com/blog/?page_id=393/help/searchoptions-searchfield-undefined#p25577 Hi,

Not sure if you are still looking for an answer to this, but just in case, this is how I got this working:

You need to create a second array for the items you want to appear in the dropdown, then assign that array to the value of the sortoptions.  For example, I have an array called myData, which contains all the data for the grid.  After populating this, but before I draw the grid itself, I create another array like so:

 var domains = ':;';
                    for (var i = 0; i <= mydata.length - 1; i++) {
                        if (domains.indexOf(mydata[i].DomainName + ':') == -1) {
                            domains += mydata[i].DomainName + ':' + mydata[i].DomainName + ';';
                        }
                    }
                    domains = domains.substring(0, domains.length - 1); // this just clears the trailing ";"

then, in the colModel, I use this for the Domain Name row:

  { name: 'DomainName', label: 'Domain Name', width: 60, editable: false, edittype: 'select', editoptions: { value: domains }, stype: 'select', searchoptions: { sopt: ['eq'], value: domains} },

This may not be the cleanest way to achieve this, so I would be interested to know if there's a better way, but this does work...                         

]]> Tue, 03 Jan 2012 17:06:50 +0200 Bluesman74cl on searchOptions.searchField = "Undefined" http://www.trirand.com/blog/?page_id=393/help/searchoptions-searchfield-undefined#p20149 Help http://www.trirand.com/blog/?page_id=393/help/searchoptions-searchfield-undefined#p20149 Hi Friends:
I have a little problem with my JQGrid.  When I try to do a search   searchOptions.searchField comes "Undefined"
Here is my code, What I'm doing wrong??

Grid

$('#grig').jqGrid(
            {
                jsonReader:             //Set the jsonReader to the JQGridJSonResponse squema to bind the data.
                {
                root: "Items",          //array containing actual data
                page: "CurrentPage",    //current page
                total: "PageCount",     //total pages for the query
                records: "RecordCount", //total number of records
                repeatitems: false,
                cell: "",
                id: 'RowNumber'        //Indice o Nombre de la columna que es PK
            },
            hidegrid: false,
            colNames: ['dd 1', 'dd 2', 'dd 3', 'dd 4', 'dd 4', 'dd 5', 'dd 6', 'dd 7', 'dd 8', 'dd 9', 'dd 10', 'dd 11','dd 12','dd 13','Modificar','Eliminar'],
            colModel: [
                      { name: 'RowNumber',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd1',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd2',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd3',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd4',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd5',  editable: false, search:false, hidden: true, align:'center'},  
                      { name: 'dd6',  editable: false, search:false, hidden: true, align:'center'},                        
                      { name: 'dd7',  editable: false, search:false, hidden: true, align:'center'},                        
                      { name: 'dd8',  align:'center', searchoptions:{sopt: ['eq']}},  
                      { name: 'dd9',  align:'center', searchoptions:{sopt: ['eq']}},  
                      { name: 'dd10', align:'center', searchoptions:{sopt: ['eq']}},
                      { name: 'dd11', align:'center', searchoptions:{sopt: ['eq']}},
                      { name: 'dd12', align:'center', searchoptions:{sopt: ['eq']}},
                      { name: 'dd13', align:'left'  , searchoptions:{sopt: ['eq']}},
                      { name: 'Edi', width: 50, /*label: 'Modificar',*/ align: 'center', formatter:agregarModificar },
                      { name: 'del', width: 50, /*label: 'Eliminar',*/  align: 'center', formatter:agregarEliminar }

                      ],

                loadtext: 'Cargando datos...',              //Texto de Carga
                loadui: 'block',
                recordtext: "{0} - {1} de {2} Sitios",
                emptyrecords: 'No hay datos para mostrar',  //Texto cuando no hay registros para mostrar
                //pgtext: 'P&aacute;g: {0} de {1}',         //Paging input control text format.
                pgButton:true,
                pgbuttons: true,
                pginput: true,
                viewrecords: true,           
                multiselect: false,
                rowNum: -1,  /*lista todas las filas del resultado*/
                loadonce: true,
                mtype: "POST",
                rownumWidth: 40,
                gridview: true,
                pager: '#paginador',
                sortname: 'RowNumber',
                viewrecords: true,
                sortorder: "asc",
                caption: "Listado",
                width: ancho - 30,
                height: alto - 160,
                onSelectRow: function(ID) {
                  flagEdicionSitio = false;
                  iRowNumber = $("#grig").getCell(ID, 0);
                  iCod_SitioCliente = $("#grig").getCell(ID, 1);
                  iId_Cliente = $("#grig").getCell(ID, 2);
                  iId_ClienteInterno = $("#grig").getCell(ID, 3);
                  iLatitud = $("#grig").getCell(ID, 4).replace(',','.');
                  iLongitud = $("#grig").getCell(ID, 5).replace(',','.');
                  iPoligono = $("#grig").getCell(ID, 6);
                  iCod_TipoSitioCliente = $("#grig").getCell(ID, 7);
                  iNomTipoSitioCliente = $("#grig").getCell(ID, 8);
                  iCod_RefSitioCliente = $("#grig").getCell(ID, 9);
                  iNomSitioCliente = $("#grig").getCell(ID, 10);
                  iDirSitioCliente = $("#grig").getCell(ID, 11);
                  iRadio = $("#grig").getCell(ID, 12);
                  iInformacionAdicional = $("#grig").getCell(ID, 13);
                  ShowSomething();
            },
            datatype: function() { lsiSomething(); }
            }).navGrid('#paginador', { del: false, add: false, edit: false, search: true, refresh: true },{}, // default settings for edit
       {}, // default settings for add
       {}, // delete instead that del:false we need this
       { multipleSearch: false }, // search options
       {});
            jQuery("#grig").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: true });

Post

                var _search = $("#grig").getGridParam("search");
                var searchOptions;
                var searchField;
                var searchOper;
                var searchString;

                if (_search == true) {
                   //Obtiene los parámetros de busqueda en caso de que la variable _search sea true
                    searchOptions = $("#grig").getPostData();
                    try{
                        searchField = searchOptions.searchField; // This Field comes Undefined
                        searchOper = searchOptions.searchOper;
                        searchString = searchOptions.searchString;
                        var limpia = "{\"PageCount\": 0, \"CurrentPage\": 1, \"RecordCount\": 0}";
                        var limpia = "{\"PageCount\": 0, \"CurrentPage\": 1, \"RecordCount\": 0}";
                        var json = eval("(" + limpia + ")");
                        var thegrid = $("#grig")[0];
                    }catch(ex){
                    }

Thanks for your Help!!!!

]]> Tue, 05 Oct 2010 18:03:46 +0300