[Question] any way to use _ILIKE_ operator?

[Adibov]

Description

I need to use the ILIKE operator on my FilterType so that the filter result becomes case-insensitive. Any other way to support a case-insensitive search on the table?

Thanks in advance

Example code

info.AddField("Name", "name", db.Varchar).
		FieldFilterable(types.FilterType{Operator: types.FilterOperatorLike}).FieldSortable() // use Ilike operator instead

[MortezaRastegarRad]

Check this pull requests

[sinaw369]

Check this pull requests

داداش یه ایدی میدی من چنتا سوال بپرسم

[MortezaRastegarRad]

Check this pull requests

داداش یه ایدی میدی من چنتا سوال بپرسم

t.me/mr_rad78

[svtarasov]

Hello @Adibov , actually it is possible to overwrite filtering using InfoPanel's QueryFilterFn. So you can create your own filtering query for ids and use operator ilike there.