Data Model
Overview
The add-in dynamically retrieves notes associated with Domino forms and views and models them as tables and views.
Note: The forms and views exposed by the add-in are limited to those exposed in the schema governed by the scope specified in DatabaseScope.
Tables
The add-in models Domino forms with the dql mode enabled as tables. Query tables to retrieve notes associated with those forms.
Note: You must set TableTypes to Forms to discover and query forms.
Available tables are listed by querying the "sys_tables" system table.
For example:
SELECT * FROM sys_tables WHERE TableName = 'Person'
Views
The add-in models Domino views as views. Query views to retrieve notes associated with those views.
Note: You must set TableTypes to Views to discover and query views.
Available views are listed by querying the "sys_tables" system table.
For example:
SELECT * FROM sys_tables WHERE TableName = '($Account)'
Columns
Available columns for tables and views are listed by querying the "sys_tablecolumns" system table.For example:
SELECT * FROM sys_tablecolumns WHERE TableName = 'Person'
Stored Procedures
Stored procedures allow you to execute function-like operations to Domino.
For example, attachments can be manipulated via the DownloadAttachment, UploadAttachment, and RemoveAttachment stored procedures.
Note Metadata
In addition to the items defined on each note, Domino exposes unid, a unique note identifier, which identifies this specific note across all databases on the server. This is available in all tables and views.
Metadata Display Configuration
The add-in supports options for controlling how tables, views, and columns are named:
By default, UseDisplayNames is set to true, and the add-in uses column labels as the names for view columns. If UseDisplayNames is set to false, the add-in displays the internal names of view columns.
If UseSimpleNames is enabled, the add-in enforces a naming scheme where only alphanumeric characters and the underscores are displayed in the table and column names. Any nonalphanumeric characters are converted to an underscore.
Null Values
Domino does not have a direct equivalent of the SQL NULL value. The add-in reports NULL values for columns in these scenarios:
- When an item is not set on a note. In Domino formulas, this is equivalent to @IsAvailable(item) = 0.
- When a single-valued item on a note is the empty text value. In Domino formulas, this is equivalent to @IsNull(item) = 1. Here, a single-valued item is an item on the base table or view where the add-in did not find any multi-value entries during type detection.