How does subpanel know where to get its data?

[rexavh]

I have a custom package built with module builder with two related modules/tables (Kits and Components). The relationship is many-many (a Kit can have many Components and a Component can feature in many Kits). The sequence of the Components in a Kit is significant and so I have added a Component Seq No field to the join table as an attribute of the relationship. I have created a ForKits subpanel in the Components module. I want this subpanel to show the Component Seq No from the join table with descriptive information from the Component table. How can I do this?

Using the Opportunity-Contacts relationship as a model I have managed to add a button/form to edit the Component Seq No (like the Opportunity-Role) and this seems to work apart from the fact that the Kit-ID and Component-ID are not being passed to the form to prepopulate the appropriate fields. Perhaps this will just work when the subpanel is showing the right data?

Thanks so much for any assistance/pointers you can give me

[mzigman]

I am searching for a similar answer in this post:
http://www.sugarcrm.com/forums/showt...t=relationship

Can you share how you added the Sequence Number? Are you able to get data to populate into the relationship table?

[Superman]

Look data/SugarBean.php for:

 /**
     * Constructs a query to fetch data for supanels and list views
     *
     * It constructs union queries for activities subpanel.
     *
     * @param Object $parentbean constructing queries for link attributes in this bean
     * @param string $order_by Optional, order by clause
     * @param string $sort_order Optional, sort order
     * @param string $where Optional, additional where clause
     *
     * Internal Function, do not overide.
     */
    function get_union_related_list($parentbean, $order_by = "", $sort_order='', $where = "",
    $row_offset = 0, $limit=-1, $max=-1, $show_deleted = 0, $subpanel_def)
    { 
  

If you follow the code of this function, you may understand that you're able to set your custom queries for fetching information in subpanels!
One more time we see how Sugar is flexible.