Page 1 of 1

Custom reports (SQL)

Posted: Fri Jan 29, 2016 7:00 pm
by jcusters
Hi,

I run several SQL queries in phpmyadmin to check/analyse data. Now I store these queries in notepad. I'm looking for an OC 2.0 admin extension to store these query definitions. Some kind of custom reports based on plain SQL. Does anybody know which extension (free or paid) to use? Thanks in advance for your help.

Regards,
Jeroen

Re: Custom reports (SQL)

Posted: Sat Jan 30, 2016 2:33 am
by IP_CAM
Do you mean something like this ?
http://www.openshop.li/

look at the page bottom...
Ernie

Re: Custom reports (SQL)

Posted: Mon Feb 01, 2016 4:37 pm
by jcusters
No, I mean a report tool in OC admin where you can create custom reports based on SQL.

For example: find products without SEO keyword
select x from y where (real sql is blocked in forum)

When I run this in phpadmin I see a list (id, name) of the products with these criteria.