Help writing SQL queries for ZuckerReports

[1kether1]

Can anybody point me in the right direction? I'm a complete beginner with SQL and I'm trying to develop reports with ZuckerReports. Is there a guide somewhere on here that shows how to access SUGAR tables and fields with sql statements?

I would sure appreciate anybody's help on this--thanks much.

Louis

[pterrell]

I suggest that you tackle this in two ways: tutorials and builders.

If you don't have a basic understanding of SQL, you should pick up a simle book that explains Selects, Joins, Key fields, and the like. Sams Teach Yourself SQL in 10 Minutes has been sitting on my reference shelf for several years and is well-thumbed. You can also Google for "SQL tutorial" and find many good sites.

Then use a SQL query buider to look at the SugarCRM database and see the tables and piece together how they work. Most of the query builder tools have a free 30-day trial. I find Navicat to be a good choice. The free phpMyAdmin that is part of the complete install of SugarCRM has a query builder, but it only builds queries on a single talbe without a join. (Someone can correct me if I'm wroing about this feature.) And your reports probably need to combine tables--the one I'm working on now combines data from leads, leads_audit, and leads_cstm.

The query builders generate the SQL code that you can then paste into iReports.

Good luck!

[1kether1]

Thanks, Pterrell. I'm off to check out Navicat.

SQL seems pretty straightforward, I'm just unclear about how to address SUGAR's tables--particularly things like left and right joins, and intermediate tables that seem to link two or more tables together for queries.

Thanks again....
Louis