Dojo Datagrid Filtering Issue
- by Zoom Pat
I am having hard time filtering a datagrid. Please help!
This is how I draw a grid.
var jsonStore = new dojo.data.ItemFileWriteStore({data:columnValues});
gridInfo = {
store: jsonStore,
queryOptions: {ignoreCase: true},
structure: layout
};
grid = new dojox.grid.DataGrid(gridInfo, "gridNode");
grid.startup();
Now if i try something like this, it works fine and gives me the rows which has the column (AGE_FROM) value equal to 63.
grid.filter({AGE_FROM:63});
but I need all kinds of filtering and not just 'equal to'
So how do I try to obtain all the rows which have AGE_FROM 63, and < 63 and <= 63 and =63.
because grid.filter({AGE_FROM:<63}); does not work
Also One other way I was thingking was to use the following
filteredStore = new dojox.jsonPath.query(filterData,"[?(@.AGE_FROM = 63]");
and then draw the grid with the filteredStore, but the above is not working for a != operator. Once I figure a good way to filter grid I need to see a way to filter out dates.
I am trying to find a good example for filtering dataGrid but most of the examples are just filtering based on the 'equal to' criteria.
Any help is highly appreciated.