To keep a long story short, this article does not work in my v9 instance (perhaps some custom extension functionality has been deprecated since v7?)
Any ideas? Thanks all!
In my case I was using it for a subpanel on a flex-relate and I found a much better workaround:
There is an example of how to use JoinTable here:
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.
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.
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?).
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?