javascript - Arbitrary index (column name) for jqGrid search -


i have jqgrid column defined follows

        name : 'idmycolumn',         index : 'idmycolumn',         width : 80,         align : 'right',         search : true,

the id name (ìdmycolumn) fine sql update operations, not search. how can change name search operation (to id, let's idmysearch)?

so need different sql column update need search. chance so?

further clarification of oleg's question below

  • how fill rowid in grid? integer value of first column
  • is idmycolumn rowid? use key: true in column? no, not rowid
  • which editing mode use? searching use (toolbar searching, searching dialog, both)? inline edit, toolbar search
  • which name need use during sorting idmycolumn column? should column name searching , sorting same? search should "idmysearch", else (sort, ..) "idmycolumn"
  • do use loadonce: true option or not? loadonce: default / false

clarification part ii:

as have not set stringresult = true somewhere (i have checked), default false. parameter hint anyway, thanks.

however, parsing of filter on server side , replace idmycolumn idmysearch. wondering if replace filter name upfront on client side before send filter server.

the solution depends hard methods use. jqgrid provides many options used change behavior of methods or format of parameters send example server. there many callbacks , events allows modify parameters before sending server. it's important understand searching parameters saved inside of postdata option. options inside of object can using $("#gridid").jqgrid("getgridparam"), alternatively can specific option, example postdata option using $("#gridid").jqgrid("getgridparam", "postdata"). returned value the reference of internal object used jqgrid. can modify , jqgrid use automatically modified value. usage of methods setgridparam not needed in case.

thus solution of problem following. add beforesearch callback filtertoolbar method, modifies idmycolumn property of postdata idmycolumn idmysearch:

$("#gridid").jqgrid("filtertoolbar", {     beforesearch: function () {         var postdata = $(this).jqgrid("getgridparam", "postdata");         if (postdata.hasownproperty("idmycolumn")) {             postdata.idmysearch = postdata.idmycolumn;             delete postdata.idmycolumn;         }     } });

-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more