How to leverage MySQL Views as a module? - Dev Answers & Best Practices - DevClub

DevClub

Dev Answers & Best Practices How to leverage MySQL Views as a module?

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

Thread Details

State Not Answered
Replies 1 reply
Subscribers 352 subscribers
Views 354 views
Users 0 members are here

Forum Actions

Jeff Bickart 11 months ago

We have a subset of data that is summarized as a view. We would like to have a Module view this data. Overall this works fine except when we perform a QRR. Sugar things that there is an issue with the table. It's a view. Thoughts on how to have Sugar skip thie view in QRR ?

0 Frédéric Rinaldi 11 months ago

Hi Jeff Bickart ,

we were using the same way for several project but there are many limitation, including the QRR and also the upgrade process.

To solve the issue of the QRR, we were include a pre-step for the QRR during which we were renaming the view (table name to temp name) and the core module table (archive table name to table name) and post-step to switch again table and view name.

That was not clean but it was working.

Fred
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel