Table filters : column not found, why ?
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
Why filters are not just modifying the table query ? I'm sure there is good reasons, I just need to understand
Thanks !
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) because it will throw a 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 !