Filter

[BETBEDER Nicolas]

Hello,

I am trying to add some filters on my kanban cards, it works perfectly with my search bar from the documentation.

But my question is how can i implement it with an array of possibilities (ex tags: ['TODO', 'PROGRESS'', 'TOTEST']), I want to add to the filter the cards with the status TODO or PROGRESS and the search.

Thanks you,

Nicolas

[Vinitha Devi Murugan]

Hi Nicolas,

Syncfusion Greetings.

We achieved your requirement by using our base library Predicate class to create composite filter criteria. We have prepared a sample below for your reference.

Sample: https://stackblitz.com/edit/complex-filtering?file=app.component.ts

UG: https://ej2.syncfusion.com/documentation/data/querying/#build-complex-filter-criteria-using-code-classlanguage-textpredicatecode

change(args: DropDownChangeArgs): void {

      let value = args.value.split(',');

      //Building complex filter criteria using `Predicate`

        let predicate: Predicate = new Predicate('Status', 'equal', value[0]);

        predicate = predicate.or('Status', 'equal', value[1]);

        let filterQuery: Query = new Query();

        if (args.value !== 'None') {

                filterQuery = new Query().where(predicate);

            }

        this.kanbanObj.query = filterQuery;

    }

    

Kindly try the above code and get back to us if you need any further assistance.

Regards,

M.Vinitha devi

[BETBEDER Nicolas]

Hello,

Thank you for you response.

And if I want to search on the filtered cards do I also have to use the predicate?

 new Query().where(predicate).search(predicate_search);

Can we create query like this?

Thank you,

Nicolas

[Vinitha Devi Murugan]

Hi Nicolas,

Thanks for your update.

No, in search method we can not use predicate. Within the second argument of the search method you can search for composite criteria using field name collections instead of predicate. We have prepared a sample below for your reference.

Sample: https://stackblitz.com/edit/complex-filtering-npnvxy?file=app.component.ts

UG: https://ej2.syncfusion.com/angular/documentation/data/querying/#searching

let value = args.value.split(',');

      //Building complex filter criteria using `Predicate`

        let predicate: Predicate = new Predicate('Status', 'equal', value[0]);

        predicate = predicate.or('Status', 'equal', value[1]);

        let filterQuery: Query = new Query();

        if (args.value !== 'None') {

                filterQuery = new Query().where(predicate).search("L", ['Id', 'Summary', "Priority"], 'contains', true);

            }

        this.kanbanObj.query = filterQuery;

Kindly try the above sample and get back to us if you need any further assistance.

Regards,

M.Vinitha devi