Home
HCL Domino Designer User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
Domino® Query Language
Domino® Query Language (DQL) is a facility running on a Domino server that provides a terse, shorthand syntax for finding documents. It supports a wide variety and complexity of search terms. It leverages existing design elements, avoiding the need to write detailed code to access them. DQL consolidates all methods in Domino for searching document contents.
Performance and resource use
DQL processing consumes memory, disk and CPU resources. To preserve those resources and to speed up query processing, optimize your queries as much as possible.

HCL Domino Designer User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
- What's new in Domino Designer 14?
  The following features are new for developers in HCL Domino® Designer 14.
- What's new in Nomad Designer?
  HCL Nomad for web browsers v1.0.10 introduces the capability to design Notes databases. For more information, see HCL Nomad for web browsers User Documentation, Nomad web Designer.
- Accessibility and keyboard shortcuts
  Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
- Application Design
  Welcome to the Application Design section of Domino® Designer Help.
- Application Management
  Welcome to the Application Management section of Domino® Designer Help.
- Domino® Query Language
  Domino® Query Language (DQL) is a facility running on a Domino server that provides a terse, shorthand syntax for finding documents. It supports a wide variety and complexity of search terms. It leverages existing design elements, avoiding the need to write detailed code to access them. DQL consolidates all methods in Domino for searching document contents.
  - Getting started
    Before you use Domino® Query Language (DQL), create the equivalent of an internal design catalog in each database against which query requests are processed. The design catalog is maintained in hidden documents within a database and provides a high-speed mechanism to find critical design data at runtime.
  - DQL syntax
    DQL can be executed in the LotusScript® or Java™ Query method on the (Notes®) Database object or the domino-db node.js API.
  - Examples of simple queries
    Here are some examples of simple queries.
  - Value data types
    Domino® features a typeless data model where any type of data can be stored in any field. In a DQL query, the type of data searched for is defined by the type of data specified in the query term:
  - Booleans
    Here are some examples that couple simple queries with Boolean processing.
  - Precedence
    DQL has a natural precedence (order of processing) where ANDed terms are processed before ORed terms.
  - in all
    The all keyword modifies the inclusive in operator to exclude all but a specified list of values.
  - contains
    New in Domino 11: In addition to using NSF scanning and view indexes, DQL provides the contains operator to process queries against full text indexes. A database must have a full text index to be processed in this way.
  - Formula Language
    Beginning in HCL Domino® 12, Formula Language can be used in Domino Query Language (DQL) search terms.
  - Text string values
    Text string evaluation is case insensitive and accent insensitive. Use a single quote (') to forces DQL processing to interpret arguments as text rather than date/times or numerals.
  - Date and time values
    DQL supports the RFC3339 standard format for date-time strings.
  - Substitution variables
    Since it is useful to run DQL queries that vary only by the values in any given term, it is tempting to build them using string construction. But building DQL queries using string construction can be a security weakness. DQL supports substitution variables in its syntax so a query can remain unchanged but differing values can be supplied.
  - View column requirements
    DQL processing requires primary collated columns for view access that must meet specific requirements.
  - Scanning limits
    Though the DQL processing engine takes measures to avoid dominating system resources, it is still possible to write and execute a runaway query. To prevent that, three limit settings are provided.
  - Performance and resource use
    DQL processing consumes memory, disk and CPU resources. To preserve those resources and to speed up query processing, optimize your queries as much as possible.
  - Domino statistics for query analysis
    If DQL is deployed on a Domino server, the show stat query command can be used to report statistics about DQL.
  - Design catalog
    For high speed access to internal information about views and view columns, DQL processing uses a design catalog that contains design data extracted from view notes. Use updall command to add a design catalog to individual databases and to keep the design catalog up to date.
  - DomQuery utility
    The DomQuery command line utility is shipped with the Domino® server and is used to compose and tune queries. Running it with the explain(-e) flag is instrumental in understanding and optimizing DQL syntax and how queries are processed.
  - explain
    The best way to understand how DQL syntax will be processed is by using the explain facility. Explain is available as a method in the DominoQuery class (Java) and NotesDominoQuery class (LotusScript) and with the DomQuery utility using the explain (-e) flag.
  - Full-Text Search
    New in Domino 14: Beginning in HCL Domino® 14, you can enter a full-text syntax query into Domino Query Language (DQL) search terms.
- Composite Applications - Design and Management
  Composite applications are a key element in a service-oriented architecture (SOA) and contextual collaboration strategy. The ability to create and edit composite applications lets you easily integrate different types of components and technologies.
- DB2® Access views
  Domino® Designer includes two types of design elements to assist you in managing data contained in DB2® enabled Notes® databases:
- Programming Overview and User Interface
  This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
- Formula Language
  This section documents the formula language.
- LotusScript® Language
  Welcome to the LotusScript® Language section of Domino® Designer Help.
- LotusScript/COM/OLE Classes
- Java/CORBA Classes
  This section documents the Java/CORBA classes.
- Connectors
  Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
- Javadoc™ for Domino® Designer related APIs
  As part of providing additional Java™ reference documentation, Domino® Designer ships with a help plugin that contains Javadoc™ for additional Domino Designer related APIs.

Performance and resource use

DQL processing consumes memory, disk and CPU resources. To preserve those resources and to speed up query processing, optimize your queries as much as possible.

There are three ways to service query terms in DQL:

NSF data scans
View entry scans
New in V11 Full text index access
New in V11.0.1 Full text index access for numeric and date-only query terms.
New in V12.0.1 Named result sets rapidly provide reusable, commonly queried DQL results.

In general, full text indexes are the most efficient to use followed by view entries and NSF summary scans, though that can vary by data cardinality, view construction and size of results. Equality searches that find a small or medium number of documents are particularly faster using views. So, it becomes important to know how the DQL engine optimizes access to use full text indexes and views. The following table illustrates the execution aspects of DQL:

Table 1. Execution aspects of DQL
Aspects of execution	Named result sets	Full text search	View scan	NSF scan
Relative speed¹	1	2	3	4
Execution order	1	1	2	3
Operations supported	`in`, `in all`	`contains`, wildcard For numeric and date-only terms: =, >, >=, <, <=	=, >, >=, <, <=, IN, ‘viewname’.column	=, >, >=, <, <=, IN
Consolidation	N/A	ANDed terms coupled	ANDed range terms coupled	All siblings executed together

¹Relative speed, where 1 is fastest and 4 is slowest.

For consolidation, DQL combines multiple terms to perform a single scan or index search operation when it is optimal. DQL also "feeds" subsequent terms with the results of prior ones, significantly limiting the overall cost. For instance, any document eliminated by term1 will not be searched when that term is ANDed with term2.

DQL processing functions very well in the mix of operational traffic on a Domino® server but it is not free in that aspect either. Read-only view access increases as does NSF summary data access. That processing is nothing new to the server, but its effect should be studied to avoid any regression in related processing.

To use the index of a view or folder, that index must have some special properties.