Nested objects - Handling

Building Investigative Solutions
1

Hello Everyone,

As we have a limitation on nested objects for aggregation and searches in siren, Need to know how to handle the nested objects.

Say for example you wanted to do a pie chart of gender. Gender is stored as an answer for Question 2.

You create a pie chart with the field answer.valuestring (which holds gender) but when you add that field to the pie it returns answer.valuestring FOR all questions.

Add a filter to the report - where item.linkID=2

The filter has no impact. Siren cannot compute the data . Even with a filter applied it shows on screen the results from every single question not just Q2.

nested_objects
nested_objects800×891 40.7 KB

Interested to see other than flattening the indices approach.

2

Hi there !

First of all, thank you for testing Siren !

Can you tell us a little bit more about your environment ? Are you using a external database with a Virtual Index ? Or are you using a normal Elastic Search index ?

When using Virtual Indexes you will find useful to check in our documentation the current existing limitations:
https://docs.support.siren.io/10.3.3/platform/en/siren-federate/connecting-to-remote-datasources/connecting-to-jdbc-datasources.html

You may reach this limitation: “Only terms aggregations can be nested inside a parent bucket aggregation”

Let me know how it goes