• Charts

    Published:

    Charts provide the ability to take any set of data from a Pivot (and in turn a SQL Wrapper) and slice and dice them in a real time environment visually like in Excel. These charts can be saved and re-used throughout the application much like SQL Wrappers, allowing you to place the charts on custom layouts anywhere for a user to see them immediately when relevant.

  • Pivot Preview View

    Published:

    The Pivot view is a dynamic pivot table that allows execution of, and displays results for, any Pivot setup in the system and it's underlying results from a SQL Wrapper. This provides a consistent and easy method for viewing and interacting with the results of the data.

  • Pivot Design View

    Published:

    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

    Published:

    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

    Published:

    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

    Published:

    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

    Published:

    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

    Published:

    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…