Hi, I am trying to use a repeating group data source constrain function (looking to an input value typed by the user) to filter the data returned from a database. So basically searching for words or part of words withing a field and only returning database entries that have that test within. The …

Hello @bonser-backup [image] Contains Keywords matching rules Database 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 p…

Yes, thankyou I worked out a workaround by converting everything to uppercase (not visually so people can still type in any case) when looking for a match. Kind of like this look at text in input 1, assume its all uppercase, now look in database text, assume that’s all uppercase and return any ‘Co…

'Contains' thats ignores case

Need help

cmarchan July 29, 2023, 12:17am 2

Hello @bonser-backup

Topic		Replies	Views
Is it possible to perform a case insensitive search? Need help	5	3016	August 27, 2022
Case sensitivity Need help	1	713	June 18, 2021
Filtering repeating group based on partial words and ignoring case Need help	3	439	March 6, 2024
Is this the right way to use "contains keyword(s)"? Need help	3	1132	January 10, 2023
Is there any way that I can tell the "Search for" and the "doesn't contain" commands to not be case sensitive in their search? Database	4	3183	October 10, 2020

'Contains' thats ignores case

Related topics