"subResults is not defined" error when using Multi reference in joined table

W 4.9.1.
NodeJS
MySQL 8

I have tables “transactions”, “parts”, “tags” and “transaction_tags”.
Last one is multi reference table, of course.
Also, “transactions” has many “parts”.

When I make select for all transactions and choose “tag” multi reference, it works nice. I see all transactions and for each of it I see all tags.


Also, when I SELECT all “parts” and JOIN “transactions” to them, it all work fine too.

But when I try to combine these tasks, I got a 500 error “subResults is not defined”.

Community Page
Last updated: