Allow choice of strategy when filtering by a sub-resource

[stoykostanchev]

GET companies?include=owner&filter[budget][$gte]=10000&filter[owner.name][$ne]=Luis.

This query returns the companies with budget over 10000, whose owner is not Luis.
Imagine there are 20 companies and 20000 users. The current algorithm fetches all users, that are not named Luis, and adds a filter on the owner Id when looking for the companies.

We should allow the developer to use the reversed strategy -> fetch all companies first, add a company id filter when looking for the owners, that are not Luis, and after getting the results - remove of the initial set of companies the companies, whose owner didn't appear in the second query.

[henricook]

Hi @stoykostanchev!

Just to read this back to you

Currently: Gets all users $ne Luis (19999 users), then appends them all to the query ($ne userid1, $ne userid2 etc etc.) and runs a big ol' query on the companies table?

Desired: Get all the companies, Get Luis' user id, remove all companies with Luis' user id

Is that right?

Best Regards,

Henri