Hi everyone ! Is someone here capable to explain how/why table filters have no access to table query column ?
For example : Let's say I have a users table with a calculated "availabilityScore" column (percentage, from 0 to 100). If I want a filter for that "availabilityScore", I can't just use
->where('availabilityScore', '>', 10)
->where('availabilityScore', '>', 10)
because it will throw a
column not found
column not found
error.
Why filters are not just modifying the table query ? I'm sure there is good reasons, I just need to understand Thanks !