OpenWGA 7.7 - Query languages reference


formula

General


This search type utilizes the Lotus Domino formular language to execute queries, like it is internally used in Lotus Domino to specify the contents of views. The syntax therefor is the same as used in a view selection formulas, excluding the @Select statement.

An extensive documentation of Domino formula language can be found in the help database of the Domino Designer client software.

Domino Itemnames for OpenWGA metadata fields

To query for metadata fields of content documents you must use the internal storage names of those fields how WGA uses them to store them in domino document items. The following list shows the available metadata fields with their corresponding Domino item name.

Metadaten-Name Domino-Itemname
AUTHOR DocAuthor
BASEIMAGE GrundBMP
DESCRIPTION Kurzbeschreibung
EMAIL EMail
HTMLHEAD HTMLHead
ISHIDDENFROM HideDocWhen
KEYWORDS WebKeywords
LANGUAGE Sprache
LASTCLIENT WGAClient
LINKTARGET URLTargetFrame
MOUSEOVERIMAGE OnMouseOverBMP
READERS DocReaders
REFRESH AutoRefresh (Leerstring im Inhalt = false)
REFRESHTIME RefreshZeit
REFRESHURL RefreshLink
SELECTEDIMAGE SelectedBMP
STATUS WGStatus
STRUCTENTRY, STRUCTKEY WG_ID
TITLE Titel
TRACKINGKEYS TrackingKeys
UNIQUENAME DocName
USENAVIMAGES NavGrafiken (Leerstring im Inhalt = true)
VALIDFROM DatumAb
VALIDTO DatumBis
VERSION ContentVersion
VIRTUALLINK URLLink
VIRTUALLINKTYPE URLArt
VISIBLE DocIsHidden (1=sichtbar, 0=unsichtbar)
WFHISTORY WorkflowHistory

Examples

A simple search testing for an item:

_type="Tip"


Combining simple item testings with the AND operator:

_Partnerflag="Partner" & _CountryMark !="D-"


You can use all formula functionalities that are also available in view selection formulas, like the @adjust function that modifies dates and the @subset function that selects subsets of list values:

@adjust(@now; 0; 0;-10; 0; 0; 0) < @subset($revisions; -1)