Pain point · API & developer experience · Blocks work
Cannot create an array relationship from an array of ids
1 source thread · first seen 2021-04
Summary
A relationship from a post's media_ids array column to the media table is not supported and fails with an operator error; nested inserts of media are also impossible.
- Workaround
- A computed field to fetch media rows
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“I'm trying to create an array relationship to the 'media' table on it's 'id' column”