Kysely•15mo ago

Property does not exist on type

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();

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">'

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

Any help appreciated.

Solution:

Message Not Public

Jump to solution

7 Replies

Solution

Unknown User•15mo ago

Message Not Public

kewp•15mo ago

Hello Yes it's verion 0.23

Unknown User•15mo ago

Message Not Public

kewp•15mo ago

Ok will do

kewp•15mo ago

BTW how could I implement this expression without this new expression builder stuff ?

Igal•15mo ago

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()

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

kewp•15mo ago

Thanks so much That works great

Gaming

Programming

Property does not exist on type