This is a migrated thread and some comments may be shown as answers.

Support of filterable operators (string, number, date) and date filtering

1 Answer 193 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Dimitris asked on 25 Nov 2020, 10:31 AM

aaaae5701f813d7c4c08b55971eb576891a0.png

In jQuery kendo grid we were able to set the default filters from filterable operators.
https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/filterable.operators.date

With that we could set all the date filters search for a range from one date to another

I am trying to do the same from the directive (and not from the HTML, so please try to answer for that) with something like this:

gridSettings: GridSettings = {
        state: {
            skip: 0,
            take: 10,
            // Initial filter descriptor
            filter: {
                logic: 'and',
                filters: []
            }
        },
        columnsConfig: [
{
            field: 'publicationDate',
            title: this.translateService.instant('legislation.publication_date'),
            filterable: [{ operator: 'gte' }, { operator: 'lte' }],
            filter: 'date',
            format: '{0:dd/MM/yyyy}',
            type: 'date',
            hidden: false,
            width: 120
        }
...
I tried on  filterable of the column but I also tried on the general  filter: { filters: [ ... ] } without success.

1) Does Angular KendoGrid support this to set the default criteria for the filters for each column or type like jQuery filterable operators (string, number, date) ?

2) And a second question regarding this european format I am using for the dates on my date columns. When I apply a filter like I am doing in the attached screenshot, it's not working

Support of filterable operators (string, number, date) and date filtering

1 Answer, 1 is accepted