Quick question: We are trying to structure a "fee...
# orm-help
c
Quick question: We are trying to structure a "feed" that could contain information from say two tables (likes and follows). What is the best way to fetch data from both tables sorted in descending order? Everything I am reading online is pointing me to having to create raw UNION queries... was curious if anyone was able to solve this similar problem using just the prisma library? The problem with just two queries and then merging is that they can become out of sync if using pagination, as one table may have more data in it. Thank you!!
r
@Chase Roossin 👋 Currently
union
is the only way to do this. There’s a feature request for the same here and it would be great if you could add a 👍