Drizzle TeamDT
Drizzle Team•13mo ago•
12 replies
jsingleton37

Running into some type errors with query.where

I have a massive query that grabs rows from a table called transfer_portal_entries and joins them with a couple other tables to get the players information back that is needed to populate a page. However, when it comes to the if statements around the filters, query is underlined saying

Property 'where' is missing in type 'Omit<import("/Users/jamessingleton/Code/Businesses/redshirt-sports/node_modules/.pnpm/drizzle-orm@0.38.2_@libsql+client-wasm@0.14.0_@opentelemetry+api@1.9.0_@types+pg@8.6.1_@types_oydy3vileqrvfkrrqmsazssq7y/node_modules/drizzle-orm/pg-core/query-builders/select").PgSelectBase<"transfer_portal_entries", { id: import(...' but required in type 'Omit<import("/Users/jamessingleton/Code/Businesses/redshirt-sports/node_modules/.pnpm/drizzle-orm@0.38.2_@libsql+client-wasm@0.14.0_@opentelemetry+api@1.9.0_@types+pg@8.6.1_@types_oydy3vileqrvfkrrqmsazssq7y/node_modules/drizzle-orm/pg-core/query-builders/select").PgSelectBase<"transfer_portal_entries", { id: import(...'.ts(2741)
select.d.ts(402, 5): 'where' is declared here.


However, I am not entirely sure how to resolve this.
image.png
Was this page helpful?