Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Is there a simple example of using Mongo "find" within ReportDesigner v4.4?
jshaw
<p>Is there a simple example of using e.g. a find command against a Mongo db using the Actuate Mongo driver in v4.4, that doesn't take me back to the MongoDB documentation?</p>
<p> </p>
<p>I am connected to a MongoDB, i can pull in a whole collection, but what i really want to do is just pull in some entries. But what is the appropriate syntax because i have tried a few....</p>
<p> </p>
<p>e.g.</p>
<p> </p>
<p><span style="font-family:arial, sans-serif;font-size:small;">find( { Animals: { $in: [ "Lion", "Zebra" ] } } )</span></p>
<p> </p>
<p><span style="font-family:arial, sans-serif;font-size:small;">returns "Unable to find available fields. Error in parsing the JSON expression...."</span></p>
Find more posts tagged with
Comments
mwilliams
Select the $queryExpression... button at the bottom of the query section of the data set editor and put the following in there:<br><br>{Animals:{$in:["Lion","Zebra"]}}<br><br>That should do it. Hope this helps.
jshaw
<p>Yes, thanks, on my screen those buttons at the bottom were not visible but once I "discovered" them by scrolling down, Voila.</p>
mwilliams
Great! Glad it's working, now. Let us know whenever you have questions.