1 Answer
- Newest
- Most votes
- Most comments
2
To access elements in a collection (array, string, object ) use the SQL function get function:
In your case, use get() instead of square brackets to access your array element:
SELECT * as result FROM 'topic' where get(get(state.reported.temp,0),2) = 2
Relevant content
- asked a year ago
- asked a year ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 4 months ago