jQuery Grid Plugin - jqGrid - Topic: Customize advanced search "odata" on specified column

kweles on Customize advanced search "odata" on specified column

Thu, 13 May 2010 14:54:52 +0300

betty said:

I used jqgrid advanced search feature. The meaning of the default string in odata is not clear enough for some scientific data.

odata : ['equal', 'not equal', 'less', 'less or equal','greater','greater or equal', ...]

So I like to customized some of the string, e.g. change 'less' -> 'lower', and 'greater' to 'higher',
but the change will be on one column only.

I tried two ways so far, but have not got a solution.

Way 1: the odata will apply to all the columns in the grid.

jQuery().ready(function (){

$.extend($.jgrid.search,{Find:"Filter Results…", caption:"Filter Results…", odata:[...,'lower', 'lower and equal', 'higher', ...]});

…

}

Way 2, only the sopt part works.

colModel:[

...

    <ww:elseif test="name == 'RESOLUTION'">

        , searchoptions:{sopt:['eq','ne','lt','le','gt','ge'], odata:['equal', 'not equal','lower', 'lower and equal', 'higher','higher and equal']}
    </ww:elseif>

…

]

Any help? Thanks a lot.

hi betty!

i am from brazil, i don´t speak english, but i think that i understanded your problem:

Please, see this code:

<head>

   function MudaLabbelGrid(){
       $.jgrid.search = {
           caption: "Pesquisa Nota",
           Find: "Pesquisar",
           Reset: "Limpar",
           odata : ['Igual']
       };

$.extend($.jgrid.search,{Find:'Pesquisar'});
}

</script>

</head>
<body onload="MudaLabbelGrid()" >

</body>

i hope that help you!

tony on Customize advanced search "odata" on specified column

Wed, 12 May 2010 12:41:09 +0300

Hello,

The correct way is not to set the odata in the search options, but translate the whole array like this:

Suppose the odata has definition

odata : ['equal', 'not equal', 'less', 'less or equal','greater','greater or equal', 'begins with','does not begin with','is in','is not in','ends with','does not end with','contains','does not contain'],

then after loading jqgrid files

$.jgrid.odata = ['...here your translations ]

I see this is not very good solution, but any way I should save the existing users.

Regards

Tony

betty on Customize advanced search "odata" on specified column

Thu, 06 May 2010 22:13:45 +0300

Thank you for the fixing. I tried with a new download of jqgrid version 3.6.5, which seems having the code fixing. But I still could not get my requirement worked.

Since I only want to customize the text in the drop down box for one column, could the code be something like,

colModel:[

...

<ww:elseif test="name == 'RESOLUTION'">

, searchoptions:{sopt:['lt','le','gt','ge'], odata:['lower', 'lower and equal', 'higher','higher and equal']}
</ww:elseif>

…

]

I did not see error, but still the default odata was displayed for resolution column. Any part not right?

Thanks a lot!

tony on Customize advanced search "odata" on specified column

Tue, 04 May 2010 09:38:53 +0300

Hello,

Thanks. This is a bug. Fixed.

Best Regards

Tony

betty on Customize advanced search "odata" on specified column

Tue, 04 May 2010 01:30:48 +0300

I used jqgrid advanced search feature. The meaning of the default string in odata is not clear enough for some scientific data.

odata : ['equal', 'not equal', 'less', 'less or equal','greater','greater or equal', ...]

So I like to customized some of the string, e.g. change 'less' -> 'lower', and 'greater' to 'higher',
but the change will be on one column only.

I tried two ways so far, but have not got a solution.

Way 1: the odata will apply to all the columns in the grid.

jQuery().ready(function (){

$.extend($.jgrid.search,{Find:"Filter Results…", caption:"Filter Results…", odata:[...,'lower', 'lower and equal', 'higher', ...]});

…

}

Way 2, only the sopt part works.

colModel:[

...

<ww:elseif test="name == 'RESOLUTION'">

, searchoptions:{sopt:['eq','ne','lt','le','gt','ge'], odata:['equal', 'not equal','lower', 'lower and equal', 'higher','higher and equal']}
</ww:elseif>

…

]

Any help? Thanks a lot.