Where based on relationships?

I'm trying to query the database for a specific values which fit a filter based on relationships. Is this possible?

const result = yield* Effect.tryPromise(
            () => db.query.productUniqueId.findMany(
                {
                    // ...options,
                    where:
                        (
                            productUniqueId,
                            { and, eq }
                        ) => (
                            and(
                                eq( productUniqueId.type, type ),
                                eq( productUniqueId.product.outlets.outlet.id, outletId),
                            )
                        ),
                    with: {
                        product: {
                            columns: {},
                            with: {
                                outlets: {
                                    columns: {},
                                    with: {
                                        outlet: {
                                            columns: {
                                                id: true,
                                                name: true
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            )
        )

const result = yield* Effect.tryPromise(
            () => db.query.productUniqueId.findMany(
                {
                    // ...options,
                    where:
                        (
                            productUniqueId,
                            { and, eq }
                        ) => (
                            and(
                                eq( productUniqueId.type, type ),
                                eq( productUniqueId.product.outlets.outlet.id, outletId),
                            )
                        ),
                    with: {
                        product: {
                            columns: {},
                            with: {
                                outlets: {
                                    columns: {},
                                    with: {
                                        outlet: {
                                            columns: {
                                                id: true,
                                                name: true
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            )
        )

In the above example I got the TS2551: Property product does not exist on type - so I switched to filtering after getting the data from the database, but wanted to see if there was a way to handle this in the query

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Where based on relationships?