Triple Lock (228)
Documentation about our triple-lock suite of functionality and how to utilise it within the application itself.
Pivot Design View
The Pivot Design View allows you to drag + drop the design of your pivot, much like in Excel, from the fields in the underlying SQL Wrapper while seeing the pivot update in real time as you slice and dice your data.
Pivot View
The Pivot view enables you to view and edit basic information about the overall Pivot. Pivots are used to analyse any data in the LemonEdge platform, and any external data you want to pull into the LemonEdge platform through custom SQL Wrappers.
Pivots
Pivots provide the ability to take any set of data from a SQL Wrapper and slice and dice them in a real time environment much like Excel. These pivots can be saved and re-used throughout the application much like SQL Wrappers, allowing you to place the pivots on custom layouts anywhere for a user to see them immediately when relevant.
GetPaths
This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…
SQLWrapper Results
SQL Wrapper Results is a dynamic grid that displays allows execution of, and displays all results for, any SQL Wrapper in the system including automatically generated ones such as those created from Datasets.
This provides a consistent and easy method for viewing and interacting with results of data.GetTransactions
This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…
GetPivotedTransactions
This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…
GetPivotedAllocatedTransactions
This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…