ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: limosys on February 28, 2018, 04:18:46 am

Title: Date Filter in toolbar
Post by: limosys on February 28, 2018, 04:18:46 am

I want to filter the date column and I want to enter the date ranges in the toolbar. All the code examples I found online only explain how do this by using the column header.
Could you point me in the right direction.

Thanks
 

Title: Re: Date Filter in toolbar
Post by: paramvir on February 28, 2018, 04:51:51 pm

This one is example of toolbar filtering with filter method

https://paramquery.com/pro/demos/filter_local

https://paramquery.com/pro/api#method-filter

For date range, condition: "between" is required and 2 input fields required in the toolbar.

Title: Re: Date Filter in toolbar
Post by: limosys on March 01, 2018, 03:26:41 am

Thanks for the reply. I have managed to set up the filter but I was not able to get the datepicker to work.
I am adding custom code into the type to render a pair of textboxes for the 'to' and 'from' date.

The accountAndDateFilter function is where all the filtering happens.

I also made a type: "textbox" feild in the toolbar and assigned it the datepicker through init like in the local date filter demo.
That did not seem to work either.

As a control, I made a textbox outside the grid and assigned it a datepicker and that seem to work just fine.

Note: I am filtering locally.

Code: [Select]

//Custom HTML
var date_range_button1 =
'<input id="fromDate1" type="text" onchange="accountAndDateFilter()" class="hasDatepicker"> — <input id="toDate1" type="text" onchange="accountAndDateFilter()" class="hasDatepicker">';

//Entry in the toolbar
items: [{
type: date_range_button1 ,
}

//Executed after the grid has been initilized
$("#fromDate1").datepicker();
$("#toDate1").datepicker();


Title: Re: Date Filter in toolbar
Post by: paramvir on March 01, 2018, 05:13:07 pm

you are not supposed to add class="hasDatepicker", it's added by datepicker after initialization.

Works fine without that class.

https://plnkr.co/edit/6he6aJ8Or6rZAfHxZxUX?p=preview