String lookupDBValue(String table, String searchField, String searchValue, String outputField)
Description
Queries a single value of outputField from an unregistered database table using the searchField=searchValue condition.
If more than one value is found, only the first hit is returned.
Parameter |
Value |
|---|---|
table |
Name of the database table. The table name will be qualified by the user name configured in arcfmut.db.tableowner. |
searchField |
Field name for the query expression. |
searchValue |
Value for the query expression. |
outputField |
Name of the field for which the value should be returned. |
Return value
The returned value is an output field string. If the query has no results, an empty string is returned.
Example:
<xsl:value-of select="utiapi:lookupDBValue('UT_C_MEDIUM','MEDIUM','E','DESCRIPTION')" />
String lookupDBValue(String table, String searchExpression, String outputField)
Description
Queries a single value of outputField from an unregistered database table, using the searchExpression condition.
If more than one value is found, only the first one is returned.
Parameter |
Value |
|---|---|
table |
Name of the database table. The table name will be qualified by the user name configured in arcfmut.db.tableowner. |
searchExpression |
Conditional expression of the query. |
outputField |
Name of the field for which the value should be returned. |
Return value
The returned value is an output field string. If the query has no results, an empty string is returned.
<xsl:value-of select="utiapi:lookupDBValue('UT_C_MAINT_TYPE','CLASS_ID=2025 AND MAINT_TYPE=8','NAME')" />
String lookupDBValueDefault(String table, String searchField, String searchValue, String outputField, String defaultValue)
Description
Queries a single value of outputField from an unregistered database table using the searchField=searchValue condition.
If more than one value is found, only the first one is returned.
Parameter |
Value |
|---|---|
table |
Name of the database table. The table name will be qualified by the user name configured in arcfmut.db.tableowner. |
searchField |
Field name of the query expression. |
searchValue |
Value of the query expression. |
outputField |
Name of the field for which the value should be returned. |
defaultValue |
Value that is returned if the query has no result. |
Return value
The returned value is an output field string. If the query has no results, the defaultValue parameter is returned.
Example:
<xsl:value-of select="utiapi:lookupDBValueDefault('UT_C_MEDIUM','MEDIUM','E','DESCRIPTION','unknown')" />
String lookupDBValueDefault(String table, String searchExpression, String outputField, String defaultValue)
Description
Queries a single outputField value from an unregistered database table, with the searchExpression condition.
If more than one value is found, only the first one is returned.
Parameter |
Value |
|---|---|
table |
Name of the database table. The table name will be qualified by the user name configured in arcfmut.db.tableowner. |
searchExpression |
Conditional expression for the query. |
outputField |
Name of the field for which the value should be returned. |
defaultValue |
Value that is returned if the query has no result. |
Return value
The returned a value is an output field string. If the query has no results. the defaultValue parameter is returned.
Example:
<xsl:value-of select="utiapi:lookupDBValueDefault('UT_C_MAINT_TYPE','CLASS_ID=2025 AND MAINT_TYPE=8','NAME','unknown type')" />
NodeList lookupXMLValue(String table, String searchField, String searchValue, String outputField, String xPath)
Description
Queries a single value of outputField from an unregistered database table using the condition searchField=searchValue.
If more than one value is found, only the first hit is returned.
Parameter |
Value |
|---|---|
table |
Name of the database table. The table name will be qualified by the user name configured in arcfmut.db.tableowner. |
searchField |
Field name for the query expression. |
searchValue |
Value for the query expression. |
outputField |
Name of the field from which the result value should be returned. The field must contain XML as content. The result value is extracted from the XML using the XPath xPath expression. |
xPath |
XPath expression to extract a value from the XML content in outputField |
Return value
A string value extracted from the XML content in the outputField using the provided XPath expression, xPath. This operation retrieves a specific value from the XML structure contained within the outputField.
If the XPath query has no results, an empty string is returned.
Example:
<xsl:value-of select="utiapi:lookupXMLValue('UTI_POSTSERVER_MSG_PROTOCOL','GIS_ID','ABC4567890123456789012','UT_XML','//class-id')" />
