Updating the UI for relational batch deletions
Let's say I have an entity that's related to a lot of other entities. If I delete it, I need to paginate through multiple tables to delete the relations first, so I schedule those.
Currently I'm setting
In places where related data is being fetched (often paginated), however, I don't see a great way to index/filter for this in queries, so filtering the result based on a list of "deleted" foreign keys is my best bet it seems, which could make paginating odd when large chunks or even entire pages are missing in the filtered result.
Just checking to see if I'm missing a better way here.
Obviously the golden ticket here is full on relationship support with cascading deletes, but something that could help in the meantime:
Currently I'm setting
isDeleted: trueIn places where related data is being fetched (often paginated), however, I don't see a great way to index/filter for this in queries, so filtering the result based on a list of "deleted" foreign keys is my best bet it seems, which could make paginating odd when large chunks or even entire pages are missing in the filtered result.
Just checking to see if I'm missing a better way here.
Obviously the golden ticket here is full on relationship support with cascading deletes, but something that could help in the meantime:
q.in()q.nin()
Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.
15,010Members
Resources
Similar Threads
Was this page helpful?
