DevClub

Dev Answers & Best Practices Can procedures be used in SugarCRM Advanced Reports?

Click here to join this group and curate your SugarClub experience.

Thread Details

State Not Answered
Replies 2 replies
Subscribers 353 subscribers
Views 318 views
Users 0 members are here

Forum Actions

Related

Can procedures be used in SugarCRM Advanced Reports?

Steffen Scheid 9 months ago

Hi,

I want to use a query in a report based on another query.

This may be possible with a select * on a subquery
or with a loop through a table and execution of a stored procedure for each entry.

Hence the question: can procedures be used in SugarCRM Advanced Reports?

Thanks!

Steffen

0 Chris Raffle 9 months ago

Hi Steffen Scheid ,

The Advanced Reports module is not capable handling stored procedures. If you are hosted in SugarCloud, their policy guide states the use of any custom database triggers or stored procedures is not permitted in that environment.

Chris

Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steffen Scheid 9 months ago

Thank you, Chris Raffle !

We are using Sugar Enterprise on-premises. Maybe it works differently there. Otherwise I'll try a select * from subquery query.

Best,
Steffen
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel