System SQL Wrappers

The platform comes with certain system SQL Wrappers as standard. These are required to perform standard system processes and provide a convenient mechanism to view or modify those behaviours.

System SQL Wrapper Features

System SQL Wrappers are marked as IsSystem so you know they are provided by the system itself and will be upgraded on new release versions.

The versioning mechanism itself ensures that the system only upgrades the system query if the version it provides is greater than the version you have deployed on your own system. See our standard version view for more information.

Caution

You will not be able to edit any standard SQL Wrappers that are marked as IsSystem unless your team has specific permissions to do so. See Teams for more information.

Some SQL Wrappers are designed to give you the ability to override their default behaviour to better incorporate their functionality into the system you have designed on the LemonEdge platform. For instance GetInstrumentSets is a standard SQL Wrapper used by the system when calculating paths, allocations, and period ends. It allows you to define groups of underlying instruments to work with.
However the default instrument set only allows matching on base properties of instruments, whereas in any system you've designed on the platform your instruments will have a greater range of attributes relevant to your business. It is natural you will want to group instrument using those properties, and you can do so in your design, and reference them in this SQL Wrapper to ensure instrument sets always return the results you require.

Standard SQL Wrappers

This is a complete list of the standard system SQL Wrappers: