Filter condition

[queensgambit9]

Hi, Im using:

Code: [Select]

$("#grid_array").pqGrid( "filter", { oper: 'replace', data: [
            { dataIndx: 'Column1', condition: 'equal', value: '0'},
            ]})
to set a filter...Would it be possible to add expression OR like 'Column1' == '0' OR 'Column2' == '0'?

[paramvir]

That would be

grid.filter({
    oper: 'replace',
    data: [
          { dataIndx: 'Column1', condition: 'equal', value: '0'},
          { dataIndx: 'Column2', condition: 'equal', value: '0'}
    ]
});

and set mode = "OR" in filterModel

http://paramquery.com/pro/api#option-filterModel

[queensgambit9]

Thanks, works fine.

Question...since I change the filterModel from default (AND) to (OR), I would like to restore after the filter is executed:

Code: [Select]

$("#grid_array").pqGrid( "option", "filterModel", { on: true, mode : "AND" } );
However this removes the filter header?

Also, regarding the filter condition...if I for the same column would like to filter on value: 1, 2 and 4...how would that looke like?

Code: [Select]

{ dataIndx: 'test', condition: 'equal', value: '0'}, // add value 1, 2 and 4...
 

[paramvir]

$("#grid_array").pqGrid( "option", "filterModel", { on: true, mode : "AND" } );

However this removes the filter header?

use $("#grid_array").pqGrid( "option", "filterModel.mode", "AND" );

if I for the same column would like to filter on value: 1, 2 and 4...how would that looke like?
Code: [Select]
{ dataIndx: 'test', condition: 'equal', value: '0'}, // add value 1, 2 and 4...

use { dataIndx: 'test', condition: 'range', value: [1,2,4] },

[queensgambit9]

Thanks. Is it possible to have more advanced expressions?

Code: [Select]

$("#grid_array").pqGrid("filter", {
oper: 'replace', data: [
    { dataIndx: 'Indx1', condition: 'equal', value: '1'},
    { dataIndx: 'Indx2', condition: 'equal', value: '2'},
    { dataIndx: 'Indx3', condition: 'equal', value: '3'}
]});
Like:
((Indx1 == '1' OR Indx2 == '1') AND Indx3 == '1') ?

[queensgambit9]

Would the above be possible?
Thanks.

[paramvir]

Such conditions are not supported.