Sugar SubPanels and SubQueries

Sugar allows you to specify a where clause in a subpanel This is useful if you want to show only certain records in the subpanel, or to filter the subpanel results, as detailed in my blog entry Filtering Sugar Subpanels. While it’s a useful feature, it does have a problem – subqueries. If you specify…


Read More

Filtering Sugar SubPanels

Sugar doesn’t have a means of filtering subpanels built into it. This is a serious drawback if you have subpanels with a lot of data in them. However, it’s possible to create your own filter with a little work. I’ll explain my solution here. First, here’s a screenshot of a notes subpanel for a client…


Read More

Analyse Sugar Queries

Database performance can have a huge affect on the performance of a web application, especially one as large and complex as SugarCRM. Tuning your database to deal with Sugar’s many queries can have a huge impact on its performance. But how do you find out what exactly Sugar is doing, and which queries are causing…


Read More