OpenWGA 7.7 - Query languages reference


view

General

This query type shows the contents of a Lotus Domino view in a custom Lotus Domino database. The result is either all documents in this view or documents filtered for special values in sorted view columns. The result is also returned in the sort order that is configured for the view.

Syntax

There are some variants of syntax for this type. The simplest syntax needs only the name of a view to query:

vwPersons


If the view contains sorted columns (which is defined in the view configuration) you can filter the view for values in this column, using the following schematic syntax:

viewname;key1[|key2|key3|...];exactMatchFlag


This syntax has three parts divided by a semicolon:
  • The view name
  • A list of key values, separated by pipe symbols. Each key value is used to filter values in a sorted view column. The first value for the first sorted column of the view, the second value for second sorted column and so on
  • A "exactMatch" flag, which should be either "true" or "false". When choosing true you will get documents whose sorted column values must match the given key value exactly. When choosing false you also get all documents whose sorted column values only begin with the given key value. So a key value of "de" would also match column values "de", "de-DE", "de-AT" and so on.
An example which matches all documents whose value in the first sorted column starts with an "A":

vwPersons;A;false


Another example using two key values and needing an exact match on both:

vwPersons;Burg|Mustermann;true


"Columns only" mode

The column values for a document in the view are not available on normal queries. You can however enable the "column only" mode of view searches by adding the term "columnOnly" to query attribute "options":

<tml:query type="view" options="columnsOnly">vwPersons;Burg|Mustermann;true</tml:query>

This will let the query only return the values of the view columns for each document. Those columns are available as items with their column names (lowercased, spaces replaced by underscores "_") as item names. This mode will also return entries which are not based on regular documents, like category and total entries.

Additionally the following item names are available to further inspect the type of the view row and its data:

  • id: The Note Id. As WGA uses this as struct key a context change to this ID will go to the originating document of the view row.
  • unid: The universal id
  • searchscore: The fulltext search score, if a fulltext filter was used
  • indentlevel: The indendation level of the entry in the view
  • columnindentlevel: The indendation level of the document in its column
  • iscategory: Is true if the entry is a category
  • isdocument: Is true if the entry is based on a regular document
  • istotal: Is true if the entry is a totals line
As this mode only transports selected column values and not the complete document with all its data from the domino server to OpenWGA this mode is more resource and performance effective than normal mode.

Data returned by formula language will not represent the actual document in this mode. For example: Evaluating @DocumentUniqueID will not return the UNID of the document on which the view row is based but some internal ID.

Table of contents: