Can't get filterWhere to work with joins from another table.
Hey everyone. I am trying to recreate the following SQL (simplified demo):
the problem occurs in
filterWhere
's last parameter and I am getting a type error. Does anyone know how to fix this or if there is a workaround? I am not 100% sure why this error appears, as far as I'm concerned the SQL I am trying to generate is completely valid.
Here is a full kyse.link demo:
https://kyse.link/?p=s&i=GQxCID0h0CK3Jq2Ki7FBSolution:Jump to solution
Well, nevermind, I replaced
filterWhere
with filterWhereRef
and now it's working correctly.2 Replies