Hi, first of all sorry for my bad english, i wanna know if is possibile use the crm's sql database for create a report dashboard in an php file and how can I do it. I would like to know the number of accounts that are managed by certain users.
Hello Giorgio Tiretti,
You could use our SugarQuery method to query the Sugar database and get data. This article explains it in greater detail. This should get you started.
If you are using a commercial edition of Sugar (Pro, Corp, Ent, Ult), you can create a report for this in the Reports module and then add that report's chart as a dashlet:
If you are using Community Edition, you will need to create the dashlet through custom coding. Information on coding dashlets that will help get you started can be found in our Developer Guide.
I hope this helps!
now I check on my CRM and I look that we have the module Zucker report but i can't find anything about how to use this.
I would recommend contacting their developer. I believe this is their GitHub account so I would reach out to them via that account.
Retrieving data ...