Hi
I have this payload and want to do some comparison operation in aws iot rule:
{
"state":
{
"reported":{
"temp": [
[
1,
0,
2,
"hello world",
"-",
"",
"",
0
] ,
[]
]
}
}
}
. I want to compare if temp[0][2] is equal to 2 or not.
I have written this sql statement
SELECT * FROM '$aws/topic' WHERE state.reported.temp[0][2] = 2
but this throws following exception
SqlParseException
Expected a comparison operation: JPathNode(List(IdentNode(state), IdentNode(reported), IdentNode(temp))) state.reported.temp[0][2] =2 -------------------------------------------------^ at 1:50
So anyone up for help?
Thanks