OpenWGA 7.6 - Query languages reference

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	hdbmodel	table	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