query using Parse

Question

I want to create a query that will check in a specific class if something exist in 2 fields (I want to display for each one meaning OR and not AND) this is what I did but it's not working (Based on some examples I saw)

    PFQuery *query = [PFQuery queryWithClassName: self.parseClassName];
   [query whereKeyExists:@"name"];  //this is based on whatever query you are trying to accomplish
    [query whereKeyExists:@"city"]; //this is based on whatever query you are trying to accomplish
    [query whereKey:@"description" containsString:searchTerm];

how should I do this?

** I want to get in my query all the result the contain the searchTeam from all fields (name,city,description)

Thanks

royherma · Accepted Answer · 2014-10-27 19:07:45Z

3

the answer to this question is quite simple, just needed to add multiple whereKey method calls to the same query object. For Example:

   PFQuery *query = [PFQuery queryWithClassName: self.parseClassName];
   [query whereKey:@"name" equal:@"someName"];
   [query whereKey:@"city" equal:@"someCity"];
   [query whereKey:@"description" containsString:searchTerm];

This will evaluate as the original desired statement.

answered Oct 27, 2014 at 19:07

royherma

4,1931 gold badge35 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zoe · Accepted Answer · 2013-09-24 17:38:01Z

1

If I understood your question properly, you want to check if your searchTerm is in either name, city, or description. The way to do this is:

PFQuery * nameQuery = [PFQuery queryWithClassName: self.parseClassName];
[nameQuery whereKey:"name" containsString:searchTerm];
PFQuery * cityQuery = [PFQuery queryWithClassName: self.parseClassName];
[nameQuery whereKey:"city" containsString:searchTerm];
PFQuery * descriptionQuery = [PFQuery queryWithClassName: self.parseClassName];
[nameQuery whereKey:"description" containsString:searchTerm];

PFQuery * query = [PFQuery orQueryWithSubqueries:@[nameQuery, cityQuery, descriptionQuery]];

This creates a compound or query from an array of queries. What you were doing before by adding more constraints to the same query was the same as writing an AND query.

IE: keyExists:@"name" AND keyExists:@"city" AND description CONTAINS searchTerm

answered Sep 24, 2013 at 17:38

Zoe

111 bronze badge

2 Comments

royherma Over a year ago

I think this is incorrect, this is the same as an OR query (as the name of the method states...)

Zoe Over a year ago

What he was doing before was AND. What I wrote was OR.

Logan · Accepted Answer · 2014-10-27 19:17:34Z

You want this:

NSString *className = @"YourParseClassName";
NSString *searchTerm = @"YourSearchTerm";
PFQuery *nameQuery = [PFQuery queryWithClassName:className];
[nameQuery whereKey:@"name" containsString:searchTerm];
PFQuery *cityQuery = [PFQuery queryWithClassName:className];
[cityQuery whereKey:@"city" containsString:searchTerm];
PFQuery *descriptionQuery = [PFQuery queryWithClassName:className];
[descriptionQuery whereKey:@"description" containsString:searchTerm];

PFQuery *allQuery = [PFQuery orQueryWithSubqueries:@[nameQuery, cityQuery, descriptionQuery]];
[allQuery findObjectsInBackgroundWithBlock:^(NSArray *objects, NSError *error) {
    if (!error) {
        NSLog(@"Found objects: %@", objects);
    } else {
        NSLog(@"Received error: %@", error);
    }
}];

This way, you create your three separate queries, but then combine them into one greater query to return all the objects at once.

But keep in mind, Parse Regex searches are pretty limiting, and this might not be the most scalable option if you want a lot of searching to be done. For lightweight work or an app with occasional searching, this should be fine.

Collectives™ on Stack Overflow

query using Parse

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related