@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 alread…

Looks like: ANY FIELD CONTAINS = is case insensitive, yes. But it behaves like CONTAINS KEYWORD(S) → only searches for full words and not like CONTAINS for fragments. So not really a solution in many cases (e.g. in mine).

Any news or new ideas anybody? I would be happy if: a) I could simply apply :lowercase on both sides of the search constraint (data thing field + Input field) whereas it is currently only possible on the input side. b) there is a way to define that this condition of the search should be executed …

Is this still an issue? I can only lowercase the right hand side (user input), but not the left hand side (database field). See image below So the only workaround now is to have a duplicate database field but all-lowercase? [image]

@Dev.Appassion [image] Make Search Case Insensitive? Need help @clark.nc Another more elaborate approach is to create all your search texts as either uppercase or lowercase. When edits are done also save the same way. And when you do the search use :uppercas…

Step 1: Create a searchbox and create a workflow off of the value changing. First thing is to create a custom state on the searchbox in the workflow and set it to lowercase value of searchbox. Step 2:Next Action->Element Actions->Display List->Select the element Step 3:Data source->Search for . …

Until its possible to make it any other way without using plugins or flooding db with duplicate fields, here is what worked quite fine for me. Advanced: XXX’s NAME:lowercased contains INPUT’s value or XXX’s NAME:uppercase contains INPUT’s value or XXX’s NAME:capitalized words contains INPUT’s value…

I had the same problem and found out that you can use the free plugin called: ZQ Fuzzy Search & Autocomplete to do this. Here’s a youtube video showing how to use it. Hope this helps someone :slight_smile:

:capitalized words …does the trick for me

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

Need help Database

cmarchan September 30, 2021, 11:37pm 25

@Dev.Appassion

Topic		Replies	Views
Why is the search box case sensitive	22	9815	January 4, 2021
Trouble making search case-insensitive Database	4	526	March 18, 2024
Unique case sensitive input check condition Database	1	1127	March 30, 2022
Ensuring case sensitive unique usernames with only specific characters Database	9	4756	July 15, 2022
Contains filter only searches for words Need help	36	14488	November 25, 2019

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

Related topics