a collect join (many: true) needs an `as` (t...

Warnings reference › data-router:join-no-as

Identifier

data-router:join-no-as

Raised by

Data Router

Since

1.84.0

What happened

A collect join gathers every matching row of from into an array, and that array has to live somewhere on the left row. as names that field; without it the router cannot write the collected array anywhere, so the join is dropped and the rows pass through unenriched rather than the router throwing.

The fix

Add as - the field name the collected array is written to.

The smallest fix

join: { from: 'address', foreignKey: 'companyId', many: true, as: 'addresses' }

Reference

Covered in full at the API reference.