Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

SiteLink Support & Sales

Welcome to StorageForum!
If you're new take a look at the StorageForum Terms of Use and don't forget to check out Daily Dilbert!

writing reports

ddedde CanadaRegistered User
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!!

Comments

  • JamesFJamesF NARegistered User, Daily Operations Certified

    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_LewisEric_Lewis NCRegistered Moderator, Community Manager, SiteLink Tech Support, Daily Operations Certified, Advanced Operations Certified, Administrator Certified marketplace moderator
    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. 
Sign In or Register to comment.