• 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.

  • SQL Wrapper Columns

    Published:

    The SQL Wrapper Column view allows you to specify precisely which columns the function or stored procedure you have written will return. These columns should be created in exactly the same order and of the same name/type as the actual columns returned in your function or stored procedure.

  • SQL Wrapper Parameters

    Published:

    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

    Published:

    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.

  • Dataset Columns View

    Published:

    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

    Published:

    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

    Published:

    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.

  • Version View

    Published:

    The Version view allows a standard method for viewing items that are versioned. This allows you to see the version, reset the version and to mark the item as being a system item or not.