× Heads up!

Issue with query in MongoDB / yudhvir12

I am geeting the followig error "Syntax error on input SQL `select JSON * from test::test limit 100`: MissingTokenException(inserted [@-1,0:0='<missing EOF>',<-1>,1:33] at :)". ran on AquaDataStudio
×
yudhvir12 reported 2017-06-17T18:37:24Z  · last modified 2017-06-17T18:37:24Z

Need Help in pulling the Recrods from an embeded array field and query the record based on the value


Dev
QA
Priority Major
Complexity Complex
Component Issue with QUery in Mongo DB
Version Aqua Data Studio 17.0.4

Hi ,

 

I using the Aqua data Studio tool and I need help from one of your dev in resolving the 2 issues below

 

1. when I am try to pull a record from mongodb, the following below query is not showing up any reocrd but the record actually exists in the mongodb.

I tried 3 different ways but no luck

select * from global_boarding_report_documents where "_id" in ('59446a9f39b9bec1d6047843')

select * from global_boarding_report_documents where "_id" = ('59446a9f39b9bec1d6047843')

select * from global_boarding_report_documents where "_id" = '59446a9f39b9bec1d6047843)

2. One of the field in my Mongodb is a Embeded Array field and how can I write a query in Aqua Data Studio tool to pull a particular value from 
Embeded Array field 

Issue #2

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017