DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
<query>¶
| Tag | Data type | Description |
|---|---|---|
| query | Object | Creates a query object. |
| select | Method | Defines the SELECT clause. |
| from | Method | Defines the FROM clause. |
| where | Method | Defines the WHERE clause. |
| groupby | Method | Defines the GROUP BY clause. |
| orderby | Method | Defines the ORDER BY clause. |
| limit | Method | Defines the LIMIT BY clause. |
| setQueryManager | Method | Defines an external query manager. |
<query [attribute]> ... </data>¶
- Description
- Creates a query object.
- Attribute
- id = "myQuery" Optional attribute but it is requested when using reference to this object. The reference will be “myQuery”.
<select>...</select>¶
- Description
- Defines the SELECT clause. See the tutorial for an example.
<from> ... </from>¶
- Description
- Defines the FROM clause. See the tutorial for an example.
<where> ... </where>¶
- Description
Defines the WHERE clause. See the tutorial for an example.
You can use reference in <where> tag. For example, ###marker#myMarker### will be replaced by the marker whose "id" is "myMarker".
<groupby> ... </groupby>¶
- Description
- Defines the GROUP BY clause. See the tutorial for an example.
<orderby> ... </orderby>¶
- Description
- Defines the ORDER BY clause.
<limit> ... </limit>¶
- Description
- Defines the LIMIT clause.
<setQueryManager type = "managerName" uid = "integer" [marker1 = "definition" … markerN = "definition"]/>¶
- Description
- Defines an external query manager.
- Attributes
type = "managerName" The external query manager name is defined by means of this paramater (e.g. type = "wfqbe")
uid = "integer" The integer is the uid of the record where the query is defined in the external query manager.
See the section Defining and using an external query manager in the tutorial.
marker1 to markerN are optional attributes which can be used for marker subsitution in a query defined with the query manager. The definition can either be a reference to an existing maker, e.g. "marker#myMarker" or a direct definition, e.g. "myMarker#3". In the former case, the query marker ###myMarker### will be replaced by the marker whose "id" is "MyMarker" while in the latter case it will be replaced by 3.