How to leverage MySQL Views as a module?

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 ?

Parents

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

Reply

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

Children

No Data