Is it possible to subquery with an outer table reference?

I have three tables:

  • Fundraisers
  • Users
  • MessagesSystem

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.

Hello @Tim_Jones

You can use exclude properties, but this will apply to all entries.


Thanks @Inna_Shkolnaya. I don’t think that helps in this situation.