Is it possible to subquery with an outer table reference?

General
1

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.

image
image1389×921 76.5 KB

2

Hello @Tim_Jones

You can use exclude properties, but this will apply to all entries.
https://backendless.com/docs/rest/data_working_wih_properties.html#excluding-properties

Regards,
Inna

3

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

Tim