<tml:param>
Avaliable since version 2.0.0Description:
Sets a value for a query parameter that is defined in a stored query.
Attributes:
| General WebTML attributes are hidden -> show general attributes | |||
| Name | Value(s) | Version | Usage |
Details:
In WGA it is possible for the administrator to predefined database queries. WebTML developers who want to use the stored queries do not need the knowhow about the query syntax but can use them simply by choosing their name. These stored queries can be made dynamic by defining query parameters. The administrator defines these parameters in the query while the WebTML developer can choose values for these parameters by using the param-Tag.
She chooses the parameter to set by attribute "name" and the parameter value by the content of the param-Tag.
Examples:
She chooses the parameter to set by attribute "name" and the parameter value by the content of the param-Tag.
-
A common usage scenario of stored queries is the retrieval of documents with a special key. In the following example a document of content type "customerfile" is searched that matches a special customer number. The WebTML designer who wnats to find this file in his code uses a stored query and passes the customer number to search as a query parameter to the query.
The give stored query named "customerSearch" for SQL content stores:
content.contenttype.name = 'customerfile' AND content.items['customernr'] = {%customernr%)
Could be used inside WebTML code like this:
<tml:query name="customerSearch">
<tml:param name="customernr">754</tml:param>
</tml:query>
And would result in the execution of this query
content.contenttype.name = 'customerfile' AND content.items['customernr'] = 754
Syndicate
Dokumentationen
© Innovation Gate