hey anyone know if this is possible with quick? pr...
# box-productsd
David Rogers
02/14/2023, 4:32 PMhey anyone know if this is possible with quick? probably I'm overlooking some subselect feature or something
David Rogers
02/14/2023, 4:32 PM Copy code
scopeWhereFoo() { ... }
instance.whereFoo().get(); // easy peasy
instance.withIfWhereFooIsTrueThenTrueElseFalse() // ???David Rogers
02/14/2023, 4:33 PMgoal is to add a bit column that is 1 if some scope matches otherwise 0
David Rogers
02/14/2023, 4:49 PMgoing with "is self join count greater than 0"
Copy code
function selfJoinFoo() {
return hasOne(
relationName = "<this>",
foreignKey = "<this-key>",
localKey = "<this-key>"
).whereFoo()
}
function scopeWithFooIsTrue() {
withCount( "selfJoinFoo as fooIsTrue" )
}