jQuery Grid Plugin - jqGrid - Topic: Getting Search values http://www.trirand.com/blog/?page_id=393/help/getting-search-values Simple:Press Version 5.7.5.3 Reg on Getting Search values http://www.trirand.com/blog/?page_id=393/help/getting-search-values#p21348 Help http://www.trirand.com/blog/?page_id=393/help/getting-search-values#p21348 I am using the search option to set common values in the grid: when you select a person and a period, , you can add entries to the grid for that person and period. When Add is called, I check the values of the search options (I use a custom search so they always show above the grid) to se the default values in the edit form. ThIs works, the first time.

It does not work after the first time.

My code appears below. The part I was counting on to do the work is just this much (from onInitializeForm in the addparameters):

        var searchOptions = $("#postingtime").getGridParam("postData"); 
        $("#item_fk",formid).val(searchOptions.item_fk);
        $("#item_fk").attr('disabled',true); 
        $("#calendar_period",formid).val(searchOptions.calendar_period);
        $("#calendar_period").attr('disabled',true);

The first time I click Add, this seems to work, but after that it does not; it seems that it works only immediately after the search has been executed. Does this make sense?

Is there another way to get the values in the search fields? Something like $("#sg_item_fk"). I haven't been able to figure how to make this work.

Any help would be greatly appreciated.

Reg

   $("#postingtime").jqGrid( {
      url: 'wc.dll?PSProcess~AjaxGet~&Data=postingtime&Key=2&sk=33R0TBNY115112&sh=82',
      datatype: 'local',
      colNames: ['Postings for','In','Week','Project','Project','Title','ProjectID','Structure','Client','ClientID','Location','Activity','Duration','Invoice','Description','Batch'],
      colModel: [{name:'item_fk', search:true, editable:true, hidden:true, editrules:{edithidden:true, searchhidden:true}, edittype:'select', editoptions:{value:'0:Please Select;1:Brehaut, Reg J.'}, width:5 },
        {name:'calendar_period', search:true, editable:true, hidden:true, editrules:{edithidden:true, searchhidden:true}, edittype:'select', editoptions:{value:201001:January 2010;201002:February 2010;201003:March 2010;201004:April 2010;201005:May 2010;201006:June 2010;201007:July 2010;201008:August 2010;201009:September 2010;201010:October 2010;201011:November 2010;201012:December 2010;201101:January 2011'}, width:5 },
        {name:'week', align:'center', search:false, sortable:true, editable: true, edittype:'select', editoptions:{value:' 0:;2:2;4:4'}, width:60 },
        {name:'project', hidden:true, editable:true, editrules:{edithidden:true}, width:250,
          editoptions:{
            size: 59,
            maxlength: 25,
            dataInit : function(elem) {
               setTimeout(function() {
                 $(elem).autocomplete({
                     source: "wc.dll?PSProcess~AutoCompleteProject~&sk=33R0TBNY115112&sh=82" ,
                     minLength: 1,
                     select: function(event, ui) {
                         $("#project").val(ui.item.label);
                         $("#projectnumber").val(ui.item.project);
                         $("#shorttitle").val(ui.item.shorttitle);
                         $("#project_fk").val(ui.item.id);
                         $("#structure_fk").val(ui.item.structure_fk);
                         $("#client").val(ui.item.client);
                         $("#client_fk").val(ui.item.client_fk);
                         if ($("#structure_fk").val == "97") {
                             $("#tr_client").show();
                           };
                       },
                     change: function(event,ui) {
                         if(!ui.item) {
                             $("#project").val(' ');
                             $("#projectnumber").val(' ');
                             $("#shorttitle").val(' ');
                             $("#project_fk").val(' ');
                             $("#structure_fk").val(' ');
                             $("#client").val(' ');
                             $("#client_fk").val(' ');
                             $("#tr_client").hide();
                           }
                       }
                   })
                  },100)
                }
              }
            },
        {name:'projectnumber', index:'project', search:false, editable:true, editoptions:{size:'5', maxlength:'8'}, width:65 },
        {name:'shorttitle', index:'project', search:false, editable:true, editoptions:{size:'50', maxlength:'25'}, width:150 },
        {name:'project_fk', hidden:true, editable:true, width:30 },
        {name:'structure_fk', hidden:true, editable:true, width:30 },
        {name:'client', index:'client', search:false, editable:true, edittype:'text', editrules:{required:true}, width:200,
          editoptions:{
            dataInit : function(elem) {
               setTimeout(function() {
                 $(elem).autocomplete({
                     source: "wc.dll?PSProcess~AutoCompleteCV~&t=C&sk=33R0TBNY115112&sh=82" ,
                     minLength: 3,
                     select: function(event, ui) {
                         $("#client_fk").val(ui.item.id);
                         $("#client").val(ui.item.label);
                       },
                     change: function(event,ui) {
                         if(!ui.item) {
                             $("#client_fk").val(' ');
                             $("#client").val(' ');
                           }
                       }
                   })
                  },100)
                }
              }
            },
        {name:'client_fk', hidden:true, editable:true, width:30 },
        {name:'location_fk', index:'location', hidden:true, editable:true, edittype:'select', editrules:{edithidden:true}, editoptions:{value:'87:Office;88:On Site;89:Out of Calgary;91:Offshore;90:International;94:Travelling'}, width:120 },
        {name:'activity_fk', hidden:true, index:'activity', editable:true, edittype:'select', editrules:{edithidden:true}, editoptions:{value:'118:Administration;115:Annual Maintenance Support;114:Bug Fixing;112:Installation Support;92:Project Work;94:Training;119:Travel TIme'}, width:120 },
        {name:'qty', align:'right', search:false, editable:true, editoptions:{size:'5', maxlength:'5'}, width:80 },
        {name:'invoice', hidden:true, editable:true, editrules:{edithidden:true}, editoptions:{size:'5', maxlength:'5'}, width:3 },
        {name:'comment', hidden:true, sortable:false, editable:true, editrules:{ edithidden:true }, edittype:'textarea', editoptions:{rows:5,cols:60}, width:100 },
        {name:'batch_fk', align:'right', editable:false, search:false, width:60 } ],
      height: 'auto',
      altRows: true,
      altclass: 'ui-priority-secondary',
      gridview: true,
      pager: '#postingtimePager',
      pagerpos: 'center',
      recordpos: 'right',
      rowList:[10,25,50,100,999],
      page: 1,
      rowNum:25,
      recordtext:'Entries',
      loadui: 'block',
      sortname: 'project',
      sortorder: 'asc',
      viewsortcols: [true,'horizontal',true],
      hidegrid: false,
      caption: 'Posting Time',
      editurl:'wc.dll?PSProcess~AjaxPut~&Data=postingtime&sk=33R0TBNY115112&sh=82',
      loadError: function(xhr,st,err) {
        $("#postingtimeMessage").html("Type: "+st+"; Response: "+ xhr.status + " "+xhr.statusText);
        },
      loadComplete: function() {
        },
      gridComplete: function() {
        UpdateTotals();
        }
    }); 
    var sg = $("#srcpostingtime").filterGrid("postingtime",{
        gridModel:true,
        gridNames:true, 
        formtype:"vertical",
        enableSearch: true, 
        enableClear: false,
        searchButton: "Set",
        clearButton: "Default",
        autosearch: false
      })[0];
    $("#postingtime").setGridParam({datatype:'xml'});
    sg.triggerSearch()
    $("#postingtime").navGrid('#postingtimePager',{
        refresh:true,add:true,addtext:'Add',edit:true, edittext:'Edit',del:true, deltext:'Delete',search:false
         },
        {
    width: 500,
    recreateform:true,
    onInitializeForm : function (formid){// GetFindProjectButton(this)
        // hide columns not used in this installation
        $("#tr_client",formid).hide();
        $("#tr_projectnumber",formid).hide();
        $("#tr_shorttitle",formid).hide();
        $("#pData,#nData",formid).hide();
        $("#item_fk").attr('disabled',true);
        $("#calendar_period").attr('disabled',true);
        if($("#invoice").val() == 0) {
            $("#week").attr('disabled',false);
            $("#project").attr('disabled',false);
            $("#activity_fk").attr('disabled',false);
            $("#location_fk").attr('disabled',false);
            $("#qty").attr('disabled',false);
            $("#comment").attr('disabled',false);
            $("#tr_invoice",formid).hide();
          } else {
            alert('This item has been Invoiced; it can no longer be edited');
            $("#week").attr('disabled',true);
            $("#project").attr('disabled',true);
            $("#activity_fk").attr('disabled',true);
            $("#location_fk").attr('disabled',true);
            $("#qty").attr('disabled',true);
            $("#comment").attr('disabled',true);
            $("#invoice").attr('disabled',true);
            $("#tr_invoice",formid).show();
          };
      }
  }, // edit
        {
    width: 500,
    recreateform:true,
    beforeInitData : function (formid) {
        var searchOptions = $("#postingtime").getGridParam("postData");
        if(searchOptions.item_fk == 0) {
            alert('Sorry, cannot add until posting criteria entered');
            return false ; 
          }
      },
    onInitializeForm : function (formid){
// GetFindProjectButton(this)
        // hide columns not used in this installation
        $("#tr_client",formid).hide();
        $("#tr_projectnumber",formid).hide();
        $("#tr_shorttitle",formid).hide();
        var searchOptions = $("#postingtime").getGridParam("postData"); 
        $("#item_fk",formid).val(searchOptions.item_fk);
        $("#item_fk").attr('disabled',true); 
        $("#calendar_period",formid).val(searchOptions.calendar_period);
        $("#calendar_period").attr('disabled',true);
        $("#location_fk",formid).val("87");
        $("#activity_fk",formid).val("92");
        $("#tr_invoice",formid).hide();
        $("#week",formid).focus();
      }
  }, // add
        {} // delete
     );
  //-->

]]> Mon, 20 Dec 2010 01:52:38 +0200