Nelson Alberto Arbeláez
Nelson Alberto Arbeláez
@ngaspari Have found a more interesting whom to do this, I added some code to the returns' preprocessor, will public a pr in a couple of days
You can override the Returns Argument with a custom class implementing this trait ```php use Asseco\JsonQueryBuilder\Exceptions\JsonQueryBuilderException; use Illuminate\Database\Eloquent\Builder; use Illuminate\Support\Facades\DB; class PGSQLAggregations { public static function year($raw) { return "EXTRACT(YEAR...
## Example of working query ```json { "search": { "close_date": "2024-01-01;2024-12-31" }, "returns": [ "year:close_date", "month:close_date", "sum:value", "avg:value", "count:value", "max:year:close_date", "min:year:close_date", "max:month:close_date", "min:month:close_date" ], "group_by": ["year_close_date", "month_close_date"] } ``` ###...
Have added a new PR #55 for to solve this use cases. 🥳