App setup

• In ODC Portal, create a new API client with access to the environment you intend to run the app on. Portfolio management access is required
• In the apps settings, fill in client credentials and the tenant-url (REST endpoint) for your ODC installation
• Manually run the syncModel timer, or click the button in the app overview
• You can disable apps to exclude them from further sync and appearance in the SQL editor code completion
• Entities with the same name in different apps are postfixed with their app-name

Running queries

The query editor uses CodeMirror5 for code highlighting and autocomplete.No customization is installed, meaning we can not use {} for entity names. In queries, use @EntityName in stead of {EntityName}

CTRL-Enter executes the query

Queries are executed within a WITH (@Query) ... clause to enable returning of data to the frontend in JSON format. If you need to update or delete data (think twice!, no rollbacks!) you can use Run Raw to directly execute the query. In that case, no results are returned.

AGGrid (community) is used for displaying the results enabling sorting, filtering etc.

Results can be exported to xlsx. All processing of query results happens client side.

NOTE: System Entities are not exposed, but they are referenced by default by the app, so you can SELECT * FROM {User}