Document a Database View

Add a view

1. In Blueprint, open Tools > Database Views.
2. Click Add Database View.
3. Enter a Title. The view name is built from it as you type, for example "Daily Orders" becomes vw_daily_orders. The title cannot be changed later.
4. Enter a Description.
5. Paste the view's code into SQL.
6. Describe the columns in Definitions (below).
7. Click Submit.

Definitions format

Write one line per column, with five fields separated by |:

name|type|default value|mode|description
event_date|date||nullable|Date of the event in the property time zone
order_total|float|0|required|Order value including tax

Keep all four | on every line, even when a field is empty. An empty mode is shown as NULLABLE. Lines without all five fields stop the shared page from opening.

Share or reuse