Siddhi Query works with Array fields

[pranjal0811]

Does siddhi stream support the nested structure?

Let's consider I have the stream like -

eg :

{
"name" : "abc",
"id" : "xyz",
"account" : [
{"bank":"sbi","bal":100},{"bank":"pnb","bal":1000}
]
}

I have two questions-

1. How can we define the stream?
2. How the queries would work in this scenario.

from inputStream(id == 'qwerty' and account.bank == 'sbi') select "AAA" as signal insert into outputStream

Any suggestions?

[pcnfernando]

There are two approaches to achieve your requirement.

1. You can manually map the incoming complex json object to a attributes using Siddhi-map-json's custom mapping support and use the mapped attributes in the queries.
2. You can get the complete complex event as a single string attribute and thereafter parse it to a JSON Object using json:toObject() and use the functionalities in https://siddhi-io.github.io/siddhi-execution-json to extract the intended elements.

[pcnfernando]

Closing since answered. Please re-open the issue if you have any concerns.