OpenWGA 7.9 - Query languages reference

© 2024 Innovation Gate GmbH

OpenWGA supports many different database types as content sources and therefor can use a variety of different query languages for retrieving content. The structure and usage scheme of each query language is adapted to the capabilities of its database platform.

For example, a HQL query addressing a WGA Content Store on a relation database platform:

<tml:query type="hql">content.uniquename='home'</tml:query>


This  <tml:query> tag normally is contained in a < tml:collection > tag which may group the results of multiple queries and also contains a < tml:foreach >, which is responsible to produce output based on the query results. Look into the documentation of those tags to learn more about their usage.

This reference holds the documentation of all query languages available to OpenWGA. The following table specifies the available languages for each database platform.



hql / fullhql sql lucene hdbmodeltable view formula fulltext
WGA Content Store for MySQL, HSQLDB, MSSQL, Oracle, DB2, PostgreSQL
X
X
X
X




JDBC-Database (Query only)

X







JDBC-Database with enhanced access

X



X



WGA Content Store for Lotus Domino

X





X
X
Custom Lotus Domino Database





X
X
X


Table of contents