Property does not exist on type

Kkewp5/12/2023
Hello.

I'm trying to run the following query:

result = await db.selectFrom("data")
    .select(['partner_cd','reporter_cd'])
    .where(({ cmpr, or, and, not, exists, selectFrom, val }) => or([
      and([
        cmpr('reporter_cd', '=', country),
        cmpr('country_cd', '=', partner)
      ]),
      and([
        cmpr('country_cd', '=', country),
        cmpr('reporter_cd', '=', partner)
      ]),
    ]))
    .execute();


but I'm getting the following error:

Property 'cmpr' does not exist on type 'WhereInterface<From<DB, "data">, "data">'


Any help appreciated.
Solution
UUUnknown User5/12/2023
Message Not Public
Sign In & Join Server To View
Kkewp5/12/2023
Hello
Kkewp5/12/2023
Yes it's verion 0.23
UUUnknown User5/12/2023
Message Not Public
Sign In & Join Server To View
Kkewp5/12/2023
Ok will do
Kkewp5/12/2023
BTW how could I implement this expression without this new expression builder stuff
Kkewp5/12/2023
?
IIgal5/12/2023
kysely
  .selectFrom("data")
  .where((wb) =>
    wb.where("reporter_cd", "=", country).where("country_cd", "=", partner),
  )
  .orWhere((wb) =>
    wb.where("country_cd", "=", country).where("reporter_cd", "=", partner),
  )
  .select(["partner_cd", "reporter_cd"])
  .execute()

https://kyse.link/?p=s&i=y4MGy7uooZhq3NKtW7o9
Kkewp5/12/2023
Thanks so much
Kkewp5/12/2023
That works great