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

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.

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

The "contains" filter typically works by checking if the specified substring appears anywhere within the target string. Here’s how it generally functions:

Exact Match: If you filter with "User experience", it will match any string that contains the exact phrase "User experience", including variations in case (if case sensitivity is not enforced).

Partial Matches: It will also find notes that contain either "User", "experience", or both as long as they appear in that order within the string. For example:

"User experience" (exact match)
"This is a User experience" (contains "User")
"Experience is key to User satisfaction" (contains "experience")
Case Sensitivity: Depending on the implementation, the filter may or may not be case-sensitive. In many systems, "user" and "User" would be treated the same, but in others, they could be different.

In summary, the "contains" filter will match any string that includes the substring "User experience" in its entirety or either of the words "User" or "experience" if they appear in that order.