I need some data from the _audit table in order to perform some excel calculations. Is it possible to use Advanced Reports along with the Excel Plug-In in order to capture this information?
Hi Jeff, good question! I have tested on my own (Sugar 6.7 Enterprise with latest Excel 2010 plugin). It's not possible to access _audit tables because all data shown in Excel plugin are:
"query wizard": only core modules (Accounts, ...) and not tables in database
"reports": all the published reports using "Reports" feature and not "Advanced reports"
Of course, a workaround is available: create a custom module in Builder and sync all data from _audit tables (triggers, logic hooks, scheduler). Then you will access to this data by Reports and Excel plugin.
Kind regards, David Sanchez Project Manager | REDK dsanchez@redk.net
Hi Jeff, good question! I have tested on my own (Sugar 6.7 Enterprise with latest Excel 2010 plugin). It's not possible to access _audit tables because all data shown in Excel plugin are:
"query wizard": only core modules (Accounts, ...) and not tables in database
"reports": all the published reports using "Reports" feature and not "Advanced reports"
Of course, a workaround is available: create a custom module in Builder and sync all data from _audit tables (triggers, logic hooks, scheduler). Then you will access to this data by Reports and Excel plugin.
Kind regards, David Sanchez Project Manager | REDK dsanchez@redk.net
