GetRecordPropertyValue (Azure Stream Analytics)

Returns the record value associated with the specified property.

Syntax

GetRecordPropertyValue ( record_expression, string_expression )  

Arguments

record_expression

Is the record expression to be evaluated as a source record. record_expression can be a column of type Record or result of another function call.

string_expression

Is the string expression to be evaluated as a record property name.

Return Types

Return type is determined by the record property type and can be any of the supported types.

Examples

In this code example, “thresholds” is a reference data name defined on the inputs tab.

SELECT   
    input.DeviceID,  
    thresholds.SensorName  
FROM input  
JOIN thresholds   
ON  
    input.DeviceId = thresholds.DeviceId  
WHERE  
    GetRecordPropertyValue(input.SensorReadings, thresholds.SensorName) > thresholds.Value  

Note that you can use dot notation to access record property fields.

SELECT   
    recordColumn.NestedFieldName1.NestedFieldName2  
FROM input  
  

See also