Hi there,
I have Users and Scores collections.
Collection schemas are:
Users
{_id: String, type: String}
Scores
{_id: String, user_id: String, passed: Boolean, value: Number}
A user can have a lot of records in Scores table (one to many)
Both collections are enough big (ten thousands records).
I need to publish only users with type = ‘’ and only if they have records in Scores where attribute passed is true.
In SQL DB I may write the query like:
SELECT *
FROM users WHERE users.type = “”
INNER JOIN SCORES ON scores.user_id = users._id WHERE scores.passed = true
I know there are a lot meteor packages which implement reactivity relations, bu I don’t see anything with this functionality.