How to create a scope that depends on a related table field

Help me!
2

Hello @JulienGaladrim,

Thanks for your message! :raised_hands:

The first thing that came to my mind was to define a direct association BelongsTo('SalesRepresentative') in your Orders definition, but I am not sure this is doable with Sequelize :thinking:

Otherwise, you could create a smart field that would define the SalesRepresentativeId on your Order, and create the scope on it (this example could be a source of inspiration).

Finally, if you want to keep the initial solution you picked, you can have a look to this example where filters, pagination and sorting are still taken into account.

Let me know!
Thanks.