Excel Add-In for Domino

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060