filter jqxGrid by jqxDatetimeInput on the toolbar

[douglas168Participant]

Hi,

On the jqxGrid toolbar, there is jqxInput and jqxDateTimeInput. I can get the jqxGrid to filter a string column by what is inputted in jqxInput. Yet, how can get the jqxGrid to filter also by what date (yyyy-MM-dd) is in the jqxDatetimeInput?

Appreciate the help!

[douglas168Participant]

so far, I tried the following code:

var filterStartDate = “2017-11-14 11:17”;
console.log(“filtervalue:”, filtervalue);
var filter_or_operator = 1;

var startDateFilterGroup = new $.jqx.filter();
startDateFilterGroup.operator = ‘or’;
var startDateFilter = startDateFilterGroup.createfilter(‘datefilter’, filterStartDate, ‘GREATER_THAN_OR_EQUAL’);
startDateFilterGroup.addfilter(filter_or_operator, startDateFilter);
$(“#jqxgrid”).jqxGrid(‘addfilter’, ‘recordDate’, startDateFilterGroup);

I tried above code but no luck in filtering by date. The date format in the jqxGrid column is yyyy-MM-dd hh:mm . and not sure what format should the filterStartDate be so that any date greater than it will be filtered out?

Appreciatge the help!

[HristoParticipant]

Hello douglas168,

Please, take a look at this example:
https://www.jseditor.io/?key=jqxgrid-filter-by-date

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[douglas168Participant]

Thank you Hristo! I will give it a try.

[Author]

Posts