Feature functions can be used in sort expressions. Most are supported only in fine sort expressions. By combining various syntaxes and statements, you can create powerful sorting features.
Feature functions
Feature functions can be used in sort expressions. Most are supported only in fine sort expressions. By combining various syntaxes and statements, you can create powerful sorting features.
kvpairs_value: Get the value of a specified field from the kvpairs clause
1. Usage:
kvpairs_value(query_key, type)
2. Parameters
query_key: The name of the field in the kvpairs clause from which to retrieve a value.
type: The data type of the value of the query_key field. Supported types are INT, FLOAT, and DOUBLE.
3. Examples
Scenario 1:
The kvpairs clause in the query string contains query_key:10. The value 10 is an integer. To retrieve the value of query_key, use the formula: kvpairs_value(query_key, INT)
Scenario 2:
The kvpairs clause in the query string contains query_key:10.1. The value 10.1 is a float. To retrieve the value of query_key, use the formula: kvpairs_value(query_key, FLOAT)
Scenario 3:
The kvpairs clause in the query string contains query_key:10.12. The value 10.12 is a double. To retrieve the value of query_key, use the formula: kvpairs_value(query_key, DOUBLE)