Share your ideas with us
720 results found
-
sir, how to update join result data in mongodb collection
update p
set p.itemno = m.itemno
from exportprocess as p
inner join masterexportprocess as m on p.id=m._id1 vote -
create a customer portal
a place where I can see he history of my subscriptions, availability dates for current subscription, download my invoices...
1 vote -
Update dialog: almost bug
After I run Update dialog the document tree is collapsed and edited document lost focus. It will be very useful to stay document expanded and with focus on the field edited.
With best regards.
2 votes -
Aggregation
the docs show
db.sales.aggregate(
[
{
$group : {
_id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" } },
totalPrice: { $sum: { $multiply: [ "$price", "$quantity" ] } },
averageQuantity: { $avg: "$quantity" },
count: { $sum: 1 }
}
}
]
)
The operation returns the following results:{ "id" : { "month" : 3, "day" : 15, "year" : 2014 }, "totalPrice" : 50, "averageQuantity" : 10, "count" : 1 }
{ "id" : { "month" : 4, "day" : 4, "year" : 2014 }, "totalPrice"…1 vote -
Visual Query Builder panel opens too wide, button to collapse it has been removed
Using release 2018.3.2:
- The Visual Query Builder panel opens too wide, restricting valuable real estate space in the main query results area.
- The "->" button to easily collapse the panel seems to have been removed. This was a great convenience, please put it back.
(Kudos on improving the layout for the AND/OR clauses, and for auto-search of the fields - great improvements.)
2 votes -
Would like to be able to save updates from the update query builder
Ideally I'd like to have something to easily switch between the query part (to be 100% sure I know what I'm updating) then show the update portion and click update.
1 vote -
Close button should close window only
Like every Mac app, when you click on the cross button on the left side of the app to close it, it should close the window but keep the app running.
1 vote -
Set Profile Level from Tree View
It would be nice to be able to change the profile level from the tree view using a right click action.
1 vote -
multiple objects of an array can be updated with different data in a single direct query
if I have multiple objects in an array there should be a way so that I can update some set of objects with different data for each object via a direct query.
1 vote -
Support bulk.find.remove()
When deleting a large amount of records, it would be great for 3T to support this method so things go faster.
1 vote -
Bug when importing a document with a field starting with $
The following document can't be inserted in a collection with Studio 3T :
{
"id" : ObjectId("5b16ade6540bd478204f08c4"),
"name" : "Extract all tags used",
"ticket": "GQ-53",
"modelQuery": "Customer",
"aggregateQuery": [
{
$unwind: '$tags'
},
{
$group: {
_id: '$tags',
count: { $sum: 1 }
}
},
{
$sort: {
count: -1
}
},
{
$project: {
_id: 0,
tag: '$id',
count: 1
}
}
],
}The same document can be inserted with mongo shell.
PS: It's a valid document when mongod is at version 3.6 or more recent.
1 vote -
Allow to select folders for import
I'm a data science student and one of my use-cases is importing 100,000 small json files in nested folders. I copied them all over to one folder but selecting all of these files tends to lock up the GUI. It would be nice to be able to select a folder for imput.
Thank you
5 votes -
add populate functional
It'll be nice if you add possibility to populate fields with type ObjectID
1 vote -
Document JSON editor - change json format
When in the editor, the json format defaults to mongo shell format for the JSON, i.e. retaining 'NumberInt(10)' instead of '10'.
This can make editing the json, especially if copying from spreadsheets, really fiddly. I'd like to be able to toggle to simple format
In fact when I need to do this, I use robo 3T instead.
1 vote -
Read, tail, and parse server logs
Add the ability to read, tail, and parse the monogd and Ops Manager automation agent logs.
1 vote -
JSON Schema Editor
Any chances a JSON Schema editor for MongoDB collections will be provided in a future release?
1 vote -
"Software Update available" slows down start of Studio 3T
The "Software Update available" dialog on startup causes a bad user experience. If I start Studio 3T I want to use it as soon as possible and not mess around with an update now. As updates are important it would be better if a notification shows up during the program usage. Then I can decide when to update.
1 vote -
Add 2 features...
Feature 1: Add an option to stop Studio T3 searching the whole collection when double clicking on the collection name. I usually just want to open the collection so I can enter a query which means I have to hit the 'stop' button every time
Feature 2: Many of my searched are based on the id field. This means I have to enter the same query every time: {id: ObjectId("xxxxxxxxxxxxxxxxxxxxxxxx")}, which is a lot of typing. It would be useful to just have a field above the query field into which I can just paste an ID and it…
1 vote -
Use JavaScript ISODate methods like ISODate().getHours() or arithmetic operators directly in query/aggregate editor
So we can use it without having to mess with IntelliShell code view.
1 vote -
Support for Apple TouchBar
Support for Apple TouchBar
2 votes
- Don't see your idea?