Query Parse containsString make insensitive

Question

I wonder if someone would be able to help. I am trying to search a Parse class for a term using SearchBar. The containsString however is case sensitive and i would like it to be case insensitive. Please see code below;

-(void)filterResults:(NSString *)searchTerm {

[self.searchResults removeAllObjects];
PFQuery *query = [PFQuery queryWithClassName: @"Firefacts"];
[query whereKeyExists:@"Number"];
[query whereKey:@"Number" containsString:searchTerm];
NSArray *results = [query findObjects];
[self.searchResults addObjectsFromArray:results];
}

Any help would be greatly appreciated.

score 29 · Accepted Answer · edited May 23 '17 at 12:17

29

Use Regular Expression (?i) instead ! credit goes to https://stackoverflow.com/a/9655203/2398886 , https://stackoverflow.com/a/9655186/2398886 and http://www.regular-expressions.info/modifiers.html

So replace

[query whereKey:@"Number" containsString:searchTerm];

with

[query whereKey:@"Number" matchesRegex:[NSString stringWithFormat:@"(?i)%@",searchTerm]];

or you can also use

[query whereKey:@"Number" matchesRegex:searchTerm modifiers:@"i"];

Your final code should be :

PFQuery *query = [PFQuery queryWithClassName: @"Firefacts"];
[query whereKeyExists:@"Number"];
[query whereKey:@"Number" matchesRegex:searchTerm modifiers:@"i"];

edited May 23 '17 at 12:17

Community

1
1

answered Feb 11 '15 at 13:11

Tarsem Singh

14,139
7
51
71

3

Great answer and works a treat, thank you so much for this :-) – user3611162 Feb 12 '15 at 15:26
2

Nice ! Works perfectly with swift too :D Good job ! – user3369214 Jun 16 '15 at 12:02
I have been using this and it works. But what if I want to get an EXACT word match but also using a case insensitive regex? – D34thSt4lker May 11 '16 at 20:21
1

@D34thSt4lker then surely you would just equalTo method instead? – Supertecnoboff Jun 29 '16 at 21:04
@D34thSt4lker you can't have an EXACT insensitive match. The two contradict each other. – Brandon Stillitano Feb 01 '18 at 16:00

score 1 · Answer 2 · answered Sep 13 '19 at 18:34

1

For Swift use this:

query.whereKey("Number", matchesRegex: searchTerm, modifiers: "i")

reference: https://docs.parseplatform.org/ios/guide/#queries

answered Sep 13 '19 at 18:34

David Villegas

458
3
18

Query Parse containsString make insensitive

2 Answers2