Filter with Format and Numbers

[ahybits]

Hi

I downloaded the latest filter extension (11/25), but I can seem to get filter to work on a columnt aht has formatted with numbers.  It seems like it only works with text
        field:'completed',
        type:'numberbox',
        options:{precision:2},
        op:['equal','notequal','less','greater']

Thanks

[stworthy]

You can override or extend the operators when filtering data, the code below shows how to extend a new operator.

Code:

$.extend($.fn.datagrid.defaults.operators, {
    greater: {
        text: 'Greater',
        isMatch: function(source, value){
            return source > value;
        }
    },
    ngreater: {
        text: 'Greater',
        isMatch: function(source, value){
            return (parseFloat(source)||0) > (parseFloat(value)||0);
        }
    }
})

You also can apply the new operator on the filtering menu.

Code:

op:['equal','notequal','less','ngreater']

[ahybits]

Thanks

I tweaked it a bit as my source was <div style="....">100</div>

Code:

        ngreater: {
            text: 'Greater',
            isMatch: function(source, value){
                source = $(source).find("div").html()                
                return (parseFloat(source)||0) > (parseFloat(value)||0);
            }
        }

Thanks