Tried to use custom function to build the query. Fails because it tries to count the rows and apply filters and sorting.
Tried to make custom relation with Overriding Link2 class. Still no luck.
Is there a way to fill custom subpanel with custom data from the stored procedure?
I had similar approach. It worked perfectly well with SELECT. I call Stored Procedure (EXEC MyTestProcedure @ID = N’c664c324-8278-25da-f02c-51e9af04bb72’)
And the problem here is that after that query SuiteCRM tries to apply filtering and sorting, count the rows. Which is not applicable to Stored Procedure call.