Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
MongoDB field is array, how do I iterate a list?
Migrateduser
<p>I am querying a MongoDB datasource that is returning a single document. It has numerous subdocuments and many of them have arrays.</p>
<p> </p>
<p>When choosing a field with an array, I'd like to iterate over that array in a list or table and have the columns of the table be the fields of the array.</p>
<p> </p>
<p>For example, the selected field is: application.features[]</p>
<p> </p>
<p>The features array has "name" and "description" fields. I'd like a list of each of the feature names.</p>
<p> </p>
<p>Since the dataset returns 1 document, it only has a single row. I've done some research and not sure how to proceed.</p>
<p> </p>
<p>* Do I need to save the JSON string as a variable and use a scripted dataset to parse the JSON?</p>
<p> </p>
<p>* Is there an easier way to do this without using a scripted dataset?</p>
<p> </p>
<p>Thanks.</p>
Find more posts tagged with
Comments
There are no comments yet