Hi, I'm trying to get all my subscriptions and return all the orders linked to that subscription record.
I believe I have the schema setup correctly and have the syntax for the query correclty, but all it does is return the ID and not the entire record. If I write out the "select" in it's entirety for each column, I get a lint error. Attached some images of the schemas and the query that's not returning what' I'd like. Also attached is the result of the console log for the
subscriptionsWithAllOrders
subscriptionsWithAllOrders
query.
I'm hoping maybe I can just do a
join
join
of some kind in my
findMany
findMany
method, but no luck and not seeing any documentation on how to do this.