The <QueryTemplate>
element provides the template from which the SQL query is built.
Schema Name and Location
This element is defined by the urn:mace:shibboleth:2.0:resolver
namespace, the schema for which is located at http://shibboleth.net/schema/idp/shibboleth-attribute-resolver.xsd
Example
Typically the XML "CDATA" construct is used to wrap the text because it avoids the need for special escaping of most characters.
<QueryTemplate> <![CDATA[ SELECT * FROM people WHERE userid='$resolutionContext.principal' ]]> </QueryTemplate>
Reference
Attributes
No attributes are defined.
Child Elements
No child elements are defined.
Template Context
As enumerated below, several variables are available to the template context. In practice $resolutionContext.principal
and any dependent attributes tend to be most useful.
Name | When Valid | Description |
---|---|---|
| always | The AttributeResolutionContext. Commonly useful members include $resolutionContext. and $resolutionContext. |
| If the springResource attribute is not defined on the containing <DataConnector> | The legacy V2SAMLProfileRequestContext, provided for compatibility with most legacy SQL query templates. |
| Whenever the enclosing element has a <Dependency> element | For each IdPAttribute available from all the provided dependencies, the attributes' values are available as a collection under the attribute's name. |