OpenWGA 7.8 - Query languages reference

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)