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
0
votes
1 answer
MongoDB inserting child document on ID reference
I migrated my SQL database into a MongoDB database for a project. It migrated the foreign keys as the ID's that were already there. For example I have these two columns linked through the driversId:
My question is how do I get the driver as a…
he66el
- 55
- 5
0
votes
1 answer
How can I get my Go (Golang) program to access Cosmos DB (using the MongoDB API) through my company's proxy server?
I'm developing an app (written in Go/Golang and using the "official" MongoDB driver) that must access MongoDB databases in both MongoDB as well as Cosmos/Azure (using the MongoDB API). I use Studio3T to help out with the database tasks and my app…
Paul Uzee
- 11
- 3
0
votes
1 answer
MongoDB create user dependent view/pipeline
I just stumbled over views in MongoDB and was wondering, if it is in principle possible to create a user depedent view. For example, his user setting from a User_Settings collection.
For the view I came up with the following code, which works fine,…
Thor
- 31
- 2
0
votes
1 answer
How to split a column based on first occurrence of a delimter MongoDB
I have A column like this and it should be split based on the first "-", example is below
MGESAD :
"6095 - NCAM - US - GIUTCB - US Consumer Bank - USRB"
"6595 - NBAM - US - UDAS - Consumer Bank - USRB"
"0595 - NWWAM - US - GWCB - US BANK Bank - USRB…
user15780176
- 109
- 8
0
votes
1 answer
How to get results based on Current Date in MongoDB
How to write a query or a aggregation in mongo DB like below
select *
from final
where Week=month(todaysdate())+"-"+day(todaysdate())+"-"+year(todaysdate()))
user15780176
- 109
- 8
0
votes
0 answers
Studio3T unable to connect with mongodb
Putting mongo connection string in studio3T first gave an error that url must be encoded. My username and password had colon and string had other special characters, so I did the Url encoding
But now after pasting the Url encoded string it keeps…
0
votes
0 answers
MongoDB updatemany with arrayfilters does not update
I got this document in a collection
{
"_id" : ObjectId("1234"),
"title" : "Some Company",
"assignedPackages" : [
ObjectId("2345"),
ObjectId("3456"),
ObjectId("4567")
]
}
and this…
0
votes
2 answers
Why is my mongodb aggregation count being returned as a decimal?
The following query
db.getCollection("xyzCollection").aggregate(
[
{ $match:
{ "startDate": { $gte: ISODate("2021-01-21T00:00:00.000+0000") } , "markets": { $exists: true }}
},
{ $group:
{ _id: "$sportName"…
JL_SO
- 1,742
- 1
- 25
- 38
0
votes
2 answers
How to specify multiple nested documents in mongoimport?
I have the following CSV:
matchId, score, players.Name, players.Goals
2730319610399, 5-0, John, 3
When I use mongoimport on Studio 3T it is imported in the form I need because of the dot notation:
{
"matchId" : "2730319610399",…
user2633709
- 103
- 2
- 9
0
votes
1 answer
MONGODB Aggregate pipeline
having the following doc :
{
"_id" : ObjectId("xxx"),
"seller" : {
"phone" : {
"number" : "xx"
},
"nickname" : "xx"
},
"shipping" : {
"id" : xx
},
"id" : yyy,
"order_items" : {
"item" : {
"title" : "xxxyy"
…
Matias Ordoñez
- 105
- 7
0
votes
1 answer
Remove array element from document matching a field in array element
I have a document looking like this:
{
"_id" : ObjectId("5f60ffc5aefd067a9ff9345c"),
"_class" : "com.kalsym.smart.sms.data.MSASMS",
"number1" : NumberLong(923211105469),
"numbers2" : [
{
"field1" :…
viki
- 125
- 2
- 10
0
votes
0 answers
Mongo go driver - giving key mismatch error while connecting with ssl enabled and encrypted key
I'm getting following error while trying to connect to mongodb server from golang application kubernetes pod.
Error: tls: private key does not match public key
I'm using mongo-go-driver version 1.4.1
Key is RSA encrypted.
-----BEGIN RSA PRIVATE…
user81239
- 1
- 2
0
votes
0 answers
how to make mongodb aggregate with $in, $or $and
Here is Query in mongodb , where i used to get information on the basis of status, verify_status and their category as well as their Location, their is only one location for the field but need to find in multiple set of location.
Update : I try to…
ravi Kathait
- 1
- 3
0
votes
0 answers
Connection error with x509 auth in mongodb Studio 3t
I am using a licensed version of studio 3t and trying to setup a connection with x509.
Able to connect thru mongo shell with x509 auth with the sslPEMKeyFile & sslCAFile. Getting error in studio 3t with the same files. The pem file is protected with…
user1578872
- 7,808
- 29
- 108
- 206
0
votes
0 answers
Getting error for client data in between two timestamp range using MongoDB
I need to display particular client data in between dates. Here I have used dates are timestamp. I have worked and getting data between two timestamps but it will show overall clients count, so kindly help anyone how to get particulars client data…
Naveen J
- 63
- 13