Page 1 of 1

Query about admin

Posted: 02 Oct 2016, 18:27
by AlexYoung31
Hi,

Where abouts are the queries to form the dashboard for admin. I.e if I wanted to make one for profits.

Re: Query about admin

Posted: 02 Oct 2016, 21:13
by aimeos
The dashboard uses the Aimeos JSON API to retrieve the data:
https://aimeos.org/docs/Developers/Admi ... arch_items

To group the filtered results (like a GROUP BY), use the additional parameter

Code: Select all

aggregate=...
e.g.

Code: Select all

aggregate=order.cdate
The "columns" you can search for and group by are the same as listed in the managers. You can use the "aggregate=..." parameter for every manager that has an aggregate() method, e.g. https://github.com/aimeos/aimeos-core/b ... andard.php