search box in excel filter

Thread ID:	Created:	Updated:	Platform:	Replies:
144438	May 6,2019 05:56 PM UTC	May 8,2019 06:40 AM UTC	Angular - EJ 2	3

Subscribe to this post

Tags: Grid

ttArbor

Asked On May 6, 2019 05:56 PM UTC

is there some way I can change search operator in excel filter search box to 'contains' instead of 'startswith'?

Thank you,

Reply | Reply with quote

Pavithra Subramaniyam [Syncfusion]

Replied On May 7, 2019 05:21 AM UTC

Hi thao,

Thanks for contacting Syncfusion support.

You can change the Excel searchbox operator from ‘startswith’ to ‘contains’ by using the ‘actionBegin’ event of Grid component. Please refer to the below code example, documentation link and sample link for more information.

[component.ts]

@Component({

selector: 'app-root',

template: '<ejs-grid #grid [dataSource]='data' (actionBegin)="actionBegin($event)" allowPaging='true' allowFiltering='true' [pageSettings]='pageSettings' [filterSettings]='filterSettings'>

<e-columns>

. . .

</e-columns>

</ejs-grid>',

})

export class AppComponent {

. . .

ngOnInit(): void {

this.data = orderDataSource;

this.filterSettings = { type: 'Excel' };

}

public actionBegin(e: any): void {

if(e.requestType == 'filtersearchbegin'){

e.operator="contains";

}

Documentation: https://ej2.syncfusion.com/angular/documentation/api/grid/#actionbegin

Sample : https://stackblitz.com/edit/angular-kjhjnn-8ngpzn?file=app.component.html

Please get back to us if you need any further assistance on this.

Regards,

Pavithra S.

Reply | Reply with quote

ttArbor

Replied On May 7, 2019 02:11 PM UTC

works great!

Thanks

Reply | Reply with quote

Pavithra Subramaniyam [Syncfusion]

Replied On May 8, 2019 06:40 AM UTC

Hi thao,

Thanks for your update.

We are happy to hear that the provided solution works.

Please contact us if you need any further assistance. As always, we will be happy to assist you.

Regards,

Pavithra S.

Reply | Reply with quote

CONTACT US

search box in excel filter

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US