Triple Lock (228)
Documentation about our triple-lock suite of functionality and how to utilise it within the application itself.
SQL Wrapper Parameters
The Parameters view allows you to specify precisely the parameters your stored procedure or function take as inputs for running your sql. You can specify LemonEdge fields against them so the system knows automatically how to present selection options to the user for entering parameter values.
SQL Wrapper View
The SQL Wrapper view enables you to view and edit basic information about the overall SQL Wrapper. SQL Wrappers are used to query any information in the LemonEdge platform, and any external data you want to pull into the LemonEdge platform through custom SQL.
SQL Wrappers
SQL Wrappers form the core of our integrated reporting technology. SQL Wrappers allow the system to understand the parameters of a piece of sql along with the structure of the resulting set of data. LemonEdge allows this to be fully utilised throughout the platform in grids, charts, pivots, reports, etc.
Dataset Columns View
The Dataset column view allows you to specify precisely which columns you would like returned in your Dataset. This allows you to indicate if columns should be hidden, ordered, aggregated, etc. in an intuitive and easy to follow way.
Dataset Where Filters
Dataset Where filters allow you to create a Heirarchical where filter to apply to your Dataset to ensure you get only the results you require as efficiently as possible. These filters can apply against the Dataset parameters, and against any field for any queryable item you've included in the query.
Dataset Queryable Items View
Dataset Queryable Items allow you to specify the data you want to include in your query and the hierarchical relationships that tie the data together. The Items you can query in a Dataset come from 3 main sources; Entities, History and Queries themselves. The last one allowing you to re-query queries in a dataset.
Dataset View
The Dataset view enables you to view and edit the basic information about an overall Dataset. Datasets are used to easily query any information within the entire LemonEdge platform and return those results in a format you want. Each Dataset create a SQL Wrapper [see here] for retrieving the data and interacting with it throughout the LemonEdge platform.
Datasets
Datasets provide the ability to query every single field in the system, combine them into any shape of data you require, and even build up a library of useful queries that can be re-queryed by the dataset tool again.