Modify range values

[queensgambit9]

Would it be possible to modify values used in range condition? Fetching values remotely from DB.

Have values like 'value a, value b' but would like them to be splitted by comma (,) in the filter menu for range condition, ex:

value a, value b becomes:

- value a
- value b

[queensgambit9]

Is there a way to do it in callback in the column definition or is the prefered way to do it in the response from ajax call before values are assigned as options?

[paramvir]

Would it be possible to modify values used in range condition?

options displayed in the filter dropdown for range condition can be customized by declaring column.filter.options array or a callback returning an array.
Reference: https://paramquery.com/pro/api#option-column-filter

Also please check "(Shipped - Order) Days" in this example: https://paramquery.com/pro/demos/filter_custom

Fetching values remotely from DB.

you mean field values displayed in the grid, right?
options displayed in the filter dropdown can be built synchronously ( without separate Ajax request ) from the values displayed in the grid itself ( in case of local or no paging ) by using getDataCascade method.

http://paramquery.com/pro/api#method-getDataCascade

[queensgambit9]

I fetch filter values to populate range condition from DB (select distinct) to get all values and not only them available in grid. Tried using options but can't get it to work.
Seems to work when modifying the response from ajax call to get header options before assigning them.

Instead of equal condition in Range, I would like to use contain condition. Do I need custom override for this? Is there a sample available in that case?

Thanks.

[paramvir]

Kindly confirm whether it's local or remote filtering.

[queensgambit9]

Remote.

[paramvir]

Instead of equal condition in Range, I would like to use contain condition. Do I need custom override for this? Is there a sample available in that case?

FilterHelper::_range method can be customized as below:

Code: [Select]

public static function _range($dataIndx, &$fcrule, &$param, $value){
    $arrValue = $value;
    $fcRange = array();
    foreach ($value as $val){
        if ($val == ""){
            //continue;
            FilterHelper::_empty($dataIndx, $fcRange);
        }
        else{
            //$fcRange[] = $dataIndx."= ?";
            $fcrule[] = $dataIndx . " like CONCAT('%', ?, '%')";
            $param[] = $val;
        }
    }
    $fcrule[] = (sizeof($fcRange)>0)? "(". join(" OR ", $fcRange) .")": "";
}