iOS SDK Where Clause
I keep getting this error that I haven't seen before, and was wondering if you could shed some light (maybe I'm approaching this wrong).
3 tables are involved in this scenario:
Event --| (Optional 1:1) to Business_Location(via Location column)
Business --< (Optional 1:N) to Business_Location(via Locations column)
I want to retrieve all the events whose location's business (if specified) is "Active".
With the iOS SDK, I have this where clause specified on the query for the Event:
but I keep getting this:
I have other queries in my app that use this pattern (the lookup on the parent), and they seem to work fine (They just don't have the scenario of the three levels / tables).
If I am indeed doing this wrong, how do I check a flag against a table's (event) child's (Location) parent (Business)?