$joinRelation doesn't work within $or queries

[ewingrj]

The join relation in the following query is ignored. I'd assume that the same is true for $and.

{
  $or:[
    { $joinRelation: 'child(exists)' },
    { success: true }
  ]
}

[dekelev]

What is the raw SQL query that you're trying to run using $or & $joinRelation?

$joinRelation should be used with $eager, only in the query object's root level and without conditioning.

[ewingrj]

something like:

select * from parent join child on child.parent = parent.id where parent.success or child.id is not null```

[dekelev]

It should be possible. Maybe something like this? query: { $eager: 'child(exists)', $joinRelation: 'child(exists)', $or: { $not: { id: null }, success: true } } בתאריך יום ד׳, 16 באוק׳ 2019, 6:00, מאת RJ Ewing ‏<notifications@github.com

…

: something like: select * from parent join child on child.parent = parent.id where parent.success or child.id is not null``` — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#68?email_source=notifications&email_token=ABB5E3JJAIGQX6QZQA4HGG3QO4GAXA5CNFSM4JBAQTVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBMMKQI#issuecomment-542688577>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABB5E3PMB6TNRCQSMK46IS3QO4GAXANCNFSM4JBAQTVA> .