When having a select inside a CRUD_field it only fetches select items if there's another select with the same query in the main form (not inside the CRUD_field).

[kingmatusevich]

Without a pointless Select in the main form with the same query:
(a) the main form

(b) the CRUD with a select that doesn't show options.

With a pointless Select in the main form with the same query:
(a) the main form

(b) the CRUD with a select that now actually shows options.

Also, I'm pretty sure the joins don't work in a CRUD_field, even with the useless select.
Thank you for your great work! 😊

[kingmatusevich]

Here you can see what I meant when I said the joins don't work.

[perak]

@kingmatusevich

OK, this is two issues:

First one is because "kitchen" didn't automatically created subscription for "product" required by CRUD's insert form. Workaround is to refer that query in your page (page that contains CRUD) in related_queries. For example:

  "related_queries": [
    { "name": "product_query_name", "params": [ ] }
  ]

Second issue: CRUD currently cannot do what you are trying to implement - it's purpose is to enter simple data (not data from another collection) into array. However, it will be great to have this feature and I'll try to implement it.

[kingmatusevich]

Great, glad to hear you are on top of it, I obviously think this is an awesome feature to have as well. Let me know if I can help you somehow.
Good work 👍

[kingmatusevich]

I can confirm the workaround you posted (related_queries) does fix my issue with the subscription.

[kingmatusevich]

Of course, the CRUD doesn't traverse the Join I defined with the productId and the rest of the product fields.