Need to create a custom SQL report

  • Posts: 25
  • Thank you received: 1
10 years 7 months ago #150975

Hi,
I have to create a SQL reports for my customer and it involves tables outside of Hikashop.
Could you point me to a place where could get a head start and see the select statements for most of your reports?
For instance, list all the customers with their purchase totals for a period of time.
That way I could just merge the tables outside of hikashop in the select statements.
Thanks!

Please Log in or Create an account to join the conversation.

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
10 years 7 months ago #150995

Hi,

The simplest is to turn on the "debug system" option of the joomla configuration and display the report for which you want the SQL query. Then, look at the debug data at the bottom of the page and you'll get the SQL queries run on the page.
The one from your report should probably be the most complex one of the whole page.

The following user(s) said Thank You: reeses007

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum