Query Builder
- Add – Preview save as CSV to clipboard menu. This data can then be pasted into Excel or used as a System / Custom Dataset
- New – Expression Forecast Linear function StatisticsForecast( ) as seen in Excel where a sub query has known_y’s, known_x’s values or parameters can be passed directly in. Useful for budget forecasting
- New – Expression Exponential Growth function StatisticsGrowth( ) as seen in Excel where a sub query has known_y’s, known_x’s values or parameters can be passed directly in. Useful for budget forecasting
- New – Expression Data Row Count DataRowCount()
- Add – Suppress Zero Rows will now show up in the Table details when enabled where previously it did not.
Scheduler
- Add – Writeback Action now supported Trusted SQL connections that can reuse a Products connection instead of redefining a connection string. Local Connection mode only, (No support for Remote Connections in this mode)
- Add JavaScript new functions to support external library interop. Use to call .NET dlls or PowerShell from JavaScript. See lib_sys.interop. Requires Site Setup to trust command lines etc in Product Settings / System. Also, the path to the DLL can be restricted in Site Setup.