writing reports

dde · October 2019

I found where to write queries in the reports module. I toughest part about writing queries isn't so much the SQL but trying to find the fields required. So, does anyone know the table that the merchandize is stored. I am looking for the vendor and our cost in particular but other fields too. There is a sample report showing those fields but I can't find them in the tables in the list!!

JamesF · November 2019

There is a in built database in MySQL named ‘Information_schema’. This basically provides access to the database metadata like name of database,name of tables,columns etc. so for this purpose we will access a table named ‘tables’ in information_schema using following query.

SELECT table_name FROM information_schema.tables WHERE table_schema ='Database Name';

example

SELECT table_name FROM information_schema.tables WHERE table_schema ='test';

Eric_Lewis · November 2019

Another option is to view the schema in the in the report writer. Click on Custom Reports, Click Query, select View Schema. Now you can drill down the tables for the specific piece of data you are looking for.

writing reports

Comments

Categories