String lookupVersionedValue(String restEndPoint, String version, String layerId, String searchField, String searchValue, String outputField) throws Exception

Description

Queries a single value of outputField with the searchField=searchValue condition from a feature service layer.

If multiple values are found, only the first one is returned.

Return value

The returned value is a string representing the output field. If the query has no results, an empty string is returned.

Example:

<xsl:value-of select="utiapi:lookupVersionedValue('UTILITYNETWORK','SDE.DEFAULT','1','0003141824550443203002','FNAME')" />

String lookupVersionedValue(String restEndPoint, String version, String layerId, String searchField1, String searchValue1, String operator, String searchField2, String searchValue2, String outputField) throws Exception

Description

Queries a single value of outputField from a feature service layer, with the searchField1=searchValue1 condition and searchField2=searchValue2 operator.

If multiple values are found, only the first one is returned.

Return value

The returned value is the output field string value. If the query has no results, an empty string is returned.

Example:

<xsl:value-of select="utiapi:lookupVersionedValue('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','BL00186','AND','FNUMBER','00186','OBJ_ID')" />

String lookupVersionedValue(String restEndPoint, String version, String layerId, String searchExpression, String outputField) throws Exception

Description

Retrieves a single value of the outputField based on the condition specified in the searchExpression from a feature service layer.

If multiple values match the condition, only the first occurrence is returned.

Return value

The returned value is a string representing the output field value. If the query doesn't have any result, an empty string is returned.

Example:

<xsl:value-of select='utiapi:lookupVersionedValue("UTILITYNETWORK","SDE.DEFAULT","1","FNAME=&apos;BL00186&apos; AND FNUMBER=&apos;00186&apos;","OBJ_ID")' />

Please note that the nested quotes must be escaped: - single quote = &apos; - double quote = &quot;

In this example the search expression FNAME='BL00186' AND FNUMBER='00186' is escaped to FNAME=&apos;BL00186&apos; AND FNUMBER=&apos;00186&apos;

NodeList lookupVersionedValues(String restEndPoint, String version, String layerId, String searchField, String searchValue, String outputField) throws Exception

Description

Queries a list of outputField values from a feature service layer, using the searchExpression condition.

Return value

The returned value is a NodeList containing the output field values. If the query has no results, an empty NodeList is returned. The NodeList consists of nodes of Text type.

Example:

1.Get size of NodeList:
<xsl:value-of select="count(utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','FNUMBER'))"/>

2.Get second value from NodeList:
<xsl:value-of select="utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','FNUMBER')[2]"/>

3.Iterate over NodeList with xsl:for-each:
<xsl:for-each select="utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','FNUMBER')">
  <result><xsl:value-of select="." /></result>
</xsl:for-each>

NodeList lookupVersionedValues(String restEndPoint, String version, String layerId, String searchField1, String searchValue1, String operator, String searchField2, String searchValue2, String outputField) throws Exception

Description

Queries a list of outputField values based on the "searchField1 equals searchValue1 and searchField2 equals searchValue2" condition, from a feature service layer.

Return value

The returned value is a NodeList containing the output field values. If the query has no results, an empty NodeList is returned. The NodeList consists of nodes of Text type.

Example:

1.Get size of NodeList:
<xsl:value-of select="count(utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','OR','FNAME','Marienstr.','FNUMBER'))"/>

2.Get second value from NodeList:
<xsl:value-of select="utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','OR','FNAME','Marienstr.','FNUMBER')[2]"/>

3.Iterate over NodeList with xsl:for-each:
<xsl:for-each select="utiapi:lookupVersionedValues('UTILITYNETWORK','SDE.DEFAULT','1','FNAME','Luisenstr.','OR','FNAME','Marienstr.','FNUMBER')">
  <result><xsl:value-of select="." /></result>
</xsl:for-each>

NodeList lookupVersionedValues(String restEndPoint, String version, String layerId, String searchExpression, String outputField) throws Exception

Description

Queries a list of values of outputField with the searchExpression condition, from a feature service layer.

Return value

The returned value is a NodeList containing the output field values. If the query has no results, an empty NodeList is returned. The NodeList contains nodes of Text type.

Example:

1.Get size of NodeList:
<xsl:value-of select='count(utiapi:lookupVersionedValues("UTILITYNETWORK","SDE.DEFAULT","1","FNAME=&apos;Luisenstr.&apos; OR FNAME=&apos;Marienstr.&apos;","FNUMBER"))'/>

2.Get second value from NodeList:
<xsl:value-of select='utiapi:lookupVersionedValues("UTILITYNETWORK","SDE.DEFAULT","1","FNAME=&apos;Luisenstr.&apos; OR FNAME=&apos;Marienstr.&apos;","FNUMBER")[2]'/>

3.Iterate over NodeList with xsl:for-each:
<xsl:for-each select='utiapi:lookupVersionedValues("UTILITYNETWORK","SDE.DEFAULT","1","FNAME=&apos;Luisenstr.&apos; OR FNAME=&apos;Marienstr.&apos;","FNUMBER")'>
  <result><xsl:value-of select="." /></result>
</xsl:for-each>

Please note that the nested quotes must be escaped: - single quote = &apos; - double quote = &quot;

In this example, the FNAME='Luisenstr.' OR FNAME='Marienstr.' search expression is escaped to FNAME=&apos;Luisenstr.&apos; OR FNAME=&apos;Marienstr.&apos;