OpenWGA 7.11 - 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:
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.
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 |