Table Query Builder with Constraints
Hello everyone,
I'm working on a resource with aggregated columns ( SUM() ) where date between I've created a from date -> to date filter which works fine but now I wanted to use the QueryBuilder constraints llike NumberConstraint and I have created a new Operator which should apply a having('column_name', '>', value) but in the final query the having clause is not applied if I were to dump the query for the operator it always shows a simple query without the aggregated columns even if I overriden the getEloquentQuery method and also using query() method on the table with the exact same query. Any advice on how to handle the having and have it applied on the final query ?
Thanks you for your help.
I'm working on a resource with aggregated columns ( SUM() ) where date between I've created a from date -> to date filter which works fine but now I wanted to use the QueryBuilder constraints llike NumberConstraint and I have created a new Operator which should apply a having('column_name', '>', value) but in the final query the having clause is not applied if I were to dump the query for the operator it always shows a simple query without the aggregated columns even if I overriden the getEloquentQuery method and also using query() method on the table with the exact same query. Any advice on how to handle the having and have it applied on the final query ?
Thanks you for your help.
