String operators when reading objects

Hi!

We would like to build a search function, where we read objects with specifying filter based on the user’s search term. It will be great to use string operators like ‘Contains’ but it is not possible. Are there any plans on making them available? Or maybe you can suggest another way of implementing the search where users don’t have to type exact match in order to get results.

Screenshot 2023-10-06 at 11.34.58

1 Like

Hello!

In general, the Contains operator and its equivalents (see string operators) are client side. When setting up a data source filter, or performing a read from the database, this filtering is server side (generates queries towards the database).

The Contains operator on the database may however be used on columns/properties that has been full-text indexed. We have an experimental feature on it, but it has to be enabled manually. You may send me a DM if you need this feature!

1 Like