Use this tag for questions about Studio3T (formerly MongoChef) features and functionality.
Studio3T (formerly MongoChef) is a commercial IDE for MongoDB.
Related: robo3t
Questions tagged [studio3t]
112 questions
8
votes
6 answers
How to connect MongoDB docker by Studio 3T?
I am using docker image https://hub.docker.com/_/mongo/ (Latest MongoDB version)
I run command
docker run --name some-mongo -d mongo
Then I install Studio 3T
I enter connection information like this
but I can't connect. What is correct…
Vy Do
- 46,709
- 59
- 215
- 313
4
votes
3 answers
Limit number of objects pushed to array in MongoDB aggregation
I've been trying to find a way to limit the number of objects i'm pushing to arrays I'm creating while using "aggregate" on a MongoDB collection.
I have a collection of students - each has these relevant keys:
class number it takes this semester…
ShirMarom13
- 41
- 2
3
votes
1 answer
Error 8000 (AtlasError): '(Unauthorized) not authorized on admin to execute command
I connected to my Cluster (MongoDB Atlas) using Studio 3T. But when i click on the users button, i receive the error of the photo. I have the user ailtonjr with atlasAdmin@admin role in the Database Access and my IP in Network Access. I can delete…
Ailton
- 117
- 9
3
votes
2 answers
How to perform lead and lag in MongoDB
I am using STudio 3T and I have query like this:
select [Dashbo],lead([Dashbo]) over(order by [Entered Date])
from ATest_prevback;
This is giving me and error. How to perform this in MongoDB? Can someone give me an example?
Thanks,
Adi
user15780176
- 109
- 8
3
votes
2 answers
Failed to import the URI. Unable to look up TXT record for host cluster0-ohzuo.mongodb.net
I am trying to connect Mongodb Atlas cluster to Studio 3t.
I copied mongodb+srv://:@cluster0-ohzuo.mongodb.net/test from Mongodb account in "connect to cluster"
In Studio 3t,I went to connection manager > new connection > Import URI and pasted the…
3
votes
1 answer
How to connect to mongo server using Studio 3t behind proxy?
Using Studio 3T (free), how could I connect to a remote server if my (computer) Studio 3T is behind a proxy.
The proxy uses authentication, but I could use cntlm for handling the authentication for me.
Possible scenarios:
Studio 3T <---> Proxy…
lealceldeiro
- 14,342
- 6
- 49
- 80
2
votes
8 answers
Studio 3T for MongoDB unable to insert multiple object at once in json document in a collection
In Studio 3T i have created the collection in which i am adding a document after which popup window appears Titled >>Insert JSON Document<< to add the data in the document then i wrote these items.
{
"_id" : "5c18e1892998bdb3b3d355bf",
…
D-dingdong
- 21
- 1
- 7
2
votes
12 answers
I'm trying to insert Query in mongoDB, using Studio 3T, but keep getting this error
{
"_id" : ObjectId("5c139771d79ac8eac11e754a"),
"title" : "API",
"content" : "API stands for Application Programming Interface. It is a set of subroutine definitions, communication protocols, and tools for building software. In general…
ABHISHEK NANDKUMAR INGLE
- 21
- 1
- 3
2
votes
0 answers
What host, port to use to connect to a SQL server management studio DB in studio 3T
What I am trying to do is migrate data from a mongoDB to a SQL express DB.
I have Microsoft SQL server management studio 18 installed.
I also have Studio 3T installed (the trial).
I am trying to use the SQL migration function (mongoDB -> SQL) but I…
Robin
- 2,704
- 7
- 30
- 47
2
votes
0 answers
Studio 3T count the array length
How to count array length in particular element in studio3t?
I have tried with:
select json_array_length("Entries")
from data where "Id"='30';
this query but did not support this functions.
Ganesh Pitchai
- 55
- 8
2
votes
0 answers
Unable to connect to mongodb database via Studio3T with Authentication
I am using Ubuntu16.04 and i had enabled authorization in mongodb and created user via following.
use admin
db.createUser(
{
user: "ABC",
pwd: "XYZ",
roles: [ { role: "root", db: "admin" } ]
}
);
And after restarting mongodb server…
Jitendra
- 3,135
- 2
- 26
- 42
1
vote
0 answers
query for append id from one collection to array field of document from another collection
In Mongo database I have 2 collections . one users. two accountants . name and family fields are in both . I want to find documents which have name and family equal and add document id from collection accountants to a field array in user document.…
pedram lohery
- 13
- 2
1
vote
0 answers
Concat string to field in multiple collections
I have several collections within the same database: assessments_1, assessments_2, assessments_3, assessments_4 ect
Each of the collections has an existing fields titled "test_name" and "vendor".
When vendor = "Bridge" and test_name = "Tabulation",…
Jake
- 173
- 1
- 2
- 16
1
vote
0 answers
Not able to connect Mongodb with Studio 3T
I installed Mongodb version 6.0.3 but its not able to connect with Studio 3T and getting below error.
Connection failed.
SERVER [172.30.53.203:27017] (Type: UNKNOWN)
\_/ Connection error (MongoSocketOpenException): Exception opening socket
|____/…
Pradip Kumar
- 49
- 2
1
vote
1 answer
mongoDB query document with multiple layer of nested array
{
"sections": [
{
"desc": "no flow ID",
"sectionObj": [
{
"smartFlowIdList": []
}
]
},
{
"desc": "has flow ID",
…
user13106846
- 41
- 4