Hello,
I have written some code that initially displays a grid with all of rows from a table. The user then has the ability to filter the rows by one or more columns. One of the columns in the grid displays Date values. I would like to be able to filter the rows based on a date range specified by the user. Is this possible? If so, would someone show me how?
I have provided a snippet of the code that is filtering the grid below.
var filter = {};
if (dijit.byId('filterPNumber').getValue().length > 0)
dojo.mixin(filter, {P_NUMBER: '*' + dijit.byId('filterPNumber').getValue() + '*'});
if (dijit.byId('filterPM').getValue().length > 0)
dojo.mixin(filter, {PROJECT_MANAGER: dijit.byId('filterPM').getValue()});
if (dijit.byId('filterCName').getValue().length > 0)
dojo.mixin(filter, {CUSTOMER_NAME: '*' + dijit.byId('filterCName').getValue() + '*'});
if (dijit.byId('filterCNumber').getValue().length > 0)
dojo.mixin(filter, {CUSTOMER_NUMBER: '*' + dijit.byId('filterCNumber').getValue() + '*'});
if (dijit.byId('filterPO').getValue().length > 0)
dojo.mixin(filter, {PO_NUMBER: '*' + dijit.byId('filterPO').getValue() + '*'});
if (dijit.byId('filterCType').getValue().length > 0)
dojo.mixin(filter, {CUSTOMER_TYPE: dijit.byId('filterCType').getValue()});
dijit.byId('propGrid').filter(filter);
dijit.byId('propGrid')._refresh();
Thanks in advance!
Melanie
