OpenWGA 7.11 - 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 |
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)