Help with case + notnull.

[nrathi]

Help with this would be appreciated! I'm trying to access the "type" key but TS is complaining because it thinks it may be null. I tried to narrow the type but it's still not working. Thanks in advance.

    const queryWithNotNull = baseQuery
      .where("metadata", "is not", null)
      .$narrowType<{ metadata: NotNull }>();

      return queryWithNotNull.select((eb) =>
        eb.fn
          .sum(
            eb
              .case()
              .when(eb.ref("metadata", "->>").key("type"), "=", "some-type")
              .then(10)
              .else(0)
              .end(),
          )
          .as("some-name")

[igalklebanov]

Hey 👋

For people to help you on the internet, it's best to provide a reproduction or enough info for one.
You did neither.

Please share a kyse.link.