graphql-engine: Unable to create array relationships from array of IDs

Agree, we need this functionality too… any news on this?

We have the same requirement here but it’s on the output type of an action, we return a field called: affected_activities_ids: [Int!] and then on Hasura we want to create a relationship from this array to the actual activity table so the client can get the actual activity objects and not just the IDs.

Using a many-to-many table here doesn’t work because the data is mutable, not persisted… it’s calculated at runtime.

Also running into the same issue. We have a bulk action that does many different things, and we would like to be able to return these as something like

{
 create: [18, 19, 20],
 updated: [2, 7],
 deleted: [1, 8, 9],
}

There are ids of the items that changed. We’d like to be able to link those to ‘post’. So that we can then get the data for all the created posts, updated posts, and deleted posts.

The reason we cant return them in a single array such as [18, 19, 20, 2, 7, 1, 8, 9]. Is because A) Some items have been deleted, and we now need to delete them from the frontend B) We handle the create and updated changes differently and need to know what is new, and what updated.

Sounds like you are looking for a many-to-many relationship. You would want to create a pivot table to create the relationships between those two logical objects.

Thanks for the intention to assist. I’m aware of using an intermediate table to establish this relationship but this is not how I’m intending to structure my data. Unfortunately it seems like Hasura does not fulfill my requirements currently.

Any updates to this? Also would like to do similar attachment logic without extra tables.