Is it possible to perform a case insensitive search?

[syedammar07]

The above screenshot shows that we are performing a “Do a search” operation in the Repeating Group.

However, the results that the contains function provides are case-sensitive. Can we override this to be case-insensitive?

[mdburhan3]

Hi @syedammar07
I think Replacing contains by contains keyword do case-insensitive.

[syedammar07]

The Contains keyword method is not exactly case-insensitive. It is not even specified in the document

Anyways I tested it out and it did not work.

[mdburhan3]

@syedammar07
Sorry if i misunderstood…
Well if you are searching the whole word then contains keyword should work for case insensitive…
I agree its not mention in the docs…

You can refer to this discussion…
As @cmarchan is an expert of bubble

Contains Keywords matching rules

Hi @alan5 , My experience has been that “contains keyword(s)” returns: whole words only words in any order case insensitive words “Contains” requires: partial words words need be in precise order case sensitive words Hope this helps

@mikeloc or @adamhholmes can help (They are experts too)

[mikeloc]

This thread comes to mind when this topic comes up.

Why oh why am I unable to search the DB case insensitive?

@Bubble, I want to search for a value using “Do a search for” case insensitive. Since “Do a search for” requires a value, and it seems it’s case sensitive, it’s unable to find all potential values with the same characters. Let’s say I have a Data type with a Company Name field and Microsoft already exists. When someone else tries to add a new record with the same Company Name I want to disallow submission. So I want to ensure that all variations of case that a user types into an input field (“…

Spoiler alert: you won’t find a silver bullet in that thread, but it’s probably still worth a read.

[ed727]

@syedammar07

The Contains keyword method is not exactly case-insensitive. It is not even specified in the document

FWIW, “contains keywords” is case insensitive. That’s how it works in my app, and this has previously been discussed on the forum. (I agree, though, that this should be spelled out in the Bubble manual, since it’s a very important difference between “contains” and “contains keywords”.)