I have three tables:
I want to get -
- Fundraisers WHERE the Start Date is this week (no problem here)
- Join to Users by adding a property to the query “Users[SponsorFundraisers].email” (no problem here)
- But I want to exclude any Users rows (and by extension the fundraiser row) where a row in MessagesSystem exists for the User.objectId and the Fundraiser.objectId
I know Backendless supports NOT IN subqueries, but I don’t know how to bring the outer table reference into the subquery, or if it is even possible.