Entity setup

• Navigate to the screen ODC Entities and click Sync Database
  
• Set the toggle to off, showing all inactive found tables
  • Hint: sort on the Created On column to find the latest additions
• Edit the table of interest, give it its correct name and set it to active to enable usage in code completion
  • When editing the entity for the first time, click Update Columns to get the column definitions from the database
  • Columns still in the database but no longer in your app's model can be set to inactive to exclude them from code-completion
  • If columns are missing after a datamodel-change, sync columns again
• Hint: if you want to figure out physical table names, create a test aggregate in ODC Studio or view the data for the entity and look at the executed SQL for the physical table name(s)

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.