Thread Details
  • State Not Answered
  • Replies 1 reply
  • Subscribers 326 subscribers
  • Views 258 views
  • Users 0 members are here
Forum Actions
Related

How to leverage MySQL Views as a module?

Jeff Bickart

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

    Hi  ,

    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