Hey, is is possible to say where a joined table ha...
# orm-help
j
Hey, is is possible to say where a joined table has a column of this state or is undefined:
Copy code
where: {
    outcome: {
      OR: [
        {
          state: undefined,
        },
        {
          state: MatchOutcomeState.POSITION_ACCEPTED,
        },
        {
          state: MatchOutcomeState.POSITION_UNDER_OFFER,
        },
      ],
    },
}
Basically I want all records where there is no outcome record or if there is I want it in a specific state.