Custom subpanel in v9 (deprecetated since v7?)

Francesca Shiekh do you perhaps have an idea here. I see this older blog post refers to updates from joinRaw to joinTable, but that's still 7.x.

Thanks either way!

In my case I was using it for a subpanel on a flex-relate and I found a much better workaround:

What is the best way to add a subpanel(?) for module related via flex relate? 

There is an example of how to use JoinTable here:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_8.0/Data_Framework/Database/SugarQuery/… 

I think that is still the recommended solution in v9

Sorry I could not be of more help. You could try searching the community by "JoinRaw" there are several threads about it, maybe one of them contains a solution.

FrancescaS

Nicholas Dohmen, what issue are you running into with the code from that old blog post?

Hey Justin Kuehlthau! Thanks for the reply.

The subpanels just don't appear under the account record at all.

Thanks Francesca Shiekh! I'm trying to avoid a flex relate as it gives the user the opportunity to select the module they want to relate to and I'd like to force them to select a specific (custom) module (hence the relate field).

I'll go back to the custom subpanel posts that use joinTable (joinRaw) and will customise from there.

Thanks again!

Justin Kuehlthau have you experienced taking the Urdhva Tech article into a 9.x environment EXACTLY as per the post (i.e. adding the Opportunities With Closed Lost and Opportunities With Closed Won subpanels to Accounts?).

Reviewing Subpanels in the 9.x Developer Guide, nothing has changed- i.e. it still supports Legacy MVC Subpanel Layouts and thus the Urdhva Tech article should still work! So I'm at a loss.

I have to use a query as I have to use a relate (i.e. not a flex relate).

We have not attempted to create custom subpanels, just looking into it.  I'm not surprised that any Legacy does not work.

Have you tried the Creating Subpanels with Custom Results in Sugar 7.5 blog post code?  What doesn't work when you use it?

Hello Nicholas Dohmen,

I'm facing the same issue, I just want to add a custom subpanel in order to make a group by query within it, but nothing displays ... did you find a workaround ?

Best regards,

Enes