DateRange ServerSide FIlter by Datatable

Webix JS
#1

Hi,

There is any implementation about DateRangeFilter using serverSide for Datatable ?

#2

This seems that it does not work

webix.ui.datafilter.serverDateRangeFilter = webix.extend({
$server:true
}, webix.ui.datafilter.dateRangeFilter);
---
header:["Date", { content:"serverDateRangeFilter"}]
#3

xmm snippet looks that the scrolling does not affect datatable

http://webix.com/snippet/4fa74099

#4

I dont know maybe is not supported also for the trial version

#5

Hello,

As I can see it in the console your filter sends requests to server, but the parameters are wrong.

The value of a DateRange filter is a JSON object with start and end properties and the code does not stringify it before passing into the GET request. This is the bug within the library.

For now you can use a workaround via a custom proxy, but you will need to form the whole URL manually: http://webix.com/snippet/2a53b50a

#6

So I guess is listed as bug
Hope next version will be fixed because it is not support serverSide filtering. I ll check also multiselect.

#7

multiselect server side works fine

#8

Yep, we will provide a fix for the bug with serverside filtering using DateRange in the next build.

#9

After more investigating when we open the DatePicker we get errors

#10

.

#11

Hello,

The bug is in the DaterangePicker functionality and it has already been fixed in the updated Webix 4.2.1 Pro.

But, unfortunately, I can confirm another regression in the serverDaterangeFilter (it will send multiple requests to server). We will fixed it as soon as possible.

#12

The bug is fixed in the 4.2.4 that is already available.

#13

When we get the state of Datatable the filter of date columns have a date format like in posted image.

var state    = grid[gridId].getState();

Can we change that in settings maybe in timestamp ?

#14

There’s no such built-in possibility. The getState() returns the exact values of the filters that are in use.

You can manually format the data in the resulting object.

Or, you can redefine the getState() method of the Datatable by creating a custom component: http://webix.com/snippet/828225ce

#15

Thanks that really help :slight_smile: