opencats.org

Hi,
how does the "contains" filter exactly work in filtering.
For example if i have the string "User experience" and im filtering the "notes" field with it.

Will it only find the notes with the entire string "User experience" or with either "user" or "experience" or both.

saadaamir wrote: ↑22 May 2024, 21:09 Hi,
how does the "contains" filter exactly work in filtering.
For example if i have the string "User experience" and im filtering the "notes" field with it.snow rider

Will it only find the notes with the entire string "User experience" or with either "user" or "experience" or both.

In most basic implementations, using a "contains" filter with the string "User experience" will look for notes that include the entire substring "User experience" as it is. It won't automatically find notes with just "user" or "experience" unless the system specifically supports and is configured to perform such token-based searches or is using full-text search capabilities.

If you want to match only the exact phrase "User experience", you would need to use the "equals" filter instead, which requires the entire target field to exactly match the provided text.

saadaamir wrote: ↑22 May 2024, 21:09 Hi,
how does the "contains" filter exactly work in filtering.
For example if i have the string "User experience" and im filtering the "notes" field with it.
papa's scooperia
Will it only find the notes with the entire string "User experience" or with either "user" or "experience" or both.

In your example, filtering the "notes" field with "User experience" will find notes that contain the entire phrase "User experience" as well as any notes that include either "User" or "experience" or both, regardless of their position in the string.

The "contains" filter generally works as a substring match, meaning it looks for the exact sequence of characters within the target field.

If you filter the "notes" field with "User experience", it will return only records where the notes contain the full phrase "User experience" exactly as written (case sensitivity depends on the system).

It will not return results that contain only "User" or only "experience"—both words must appear together in the exact order specified.

If you want results that contain either word separately, you may need to use an "OR" condition or a more flexible search method like full-text search or regex, depending on the system you are using.

Are you working with a specific platform or tool? Different systems (e.g., SQL, Elasticsearch, SharePoint, Excel) may implement "contains" filtering slightly differently.
Snow Rider 3D