This post is targeted at beginner to intermediate Sugar Developers who want to add a subpanel to a module which returns custom results.
This post assumes some basic knowledge of Sugar 7 development, Sugar 7 administration, PHP, and SQL. This article will hopefully be useful to those who have done some Sugar 7 development but are not necessarily experts.
The example in this post was created on an out-of-the-box installation of Sugar Professional 184.108.40.206 with the generated demo data. But this technique should work on any on-premise Sugar 7 instance.
I recently needed to add a subpanel to a module which returned rows matching some unusual criteria. The requirement for this subpanel didn’t match the standard one-to-many or many-to-many relationship with another module that a subpanel usually reflects. I researched ways to do this and came across an excellent blog post on the subject by Shane Dowling. Following what he had written I was able to accomplish my task. This post is an attempt to make this technique accessible to those who are less familiar with Sugar 7 development.