Share your ideas with us
723 results found
-
Using SQL reserved keywords in MongoDB SQL
Suppose I have a collection named 'group'. Currently, I am unable to execute a SQL query on this collection as this is a reserved keyword in SQL and, though, manipulations like using ['group'] in SQL query don't throw any error, no result is fetched either
1 voteHi, we’ve created a ticket for this.
Meanwhile, we can help you to continue your work.
for that particular case, the following sql query should work:select *
from [group]; -
Export file naming convention
On export of an aggregation pipeline the filename of a csv for example is the filename of the last exported document. this makes sense if its the same aggregation pipeline or the same export.
When i change the pipeline it would be great to automatically (at least when the pipleine is saved as js file) to take this filename and append it with csv.
It happened to me multiple times that i export and overwrite the file that i previously exported.
also another mechanism to prevent this might help (blank filename instead of the last used one).1 vote -
Ability to auto correct the sql queries - human errors
to save time in figuring out human erros, typos, please auto correct the queries before executing.
1 vote -
Ability to extract data in XLS format
Please provide a feature to extract data in XLS format directly.
This will save lot of time to convert CSV file to XLS manaully.1 vote -
Ability to view single record feature
when I right click on one of the record, it show me a single record view option like we get in sql developer tool
1 vote -
Ability to Join more than 2 collection columns
Please allow me to join more than 2 collections using sql queries
1 vote -
Ability to query dual table
like in other databases we have dual table. we need to have such temp table in mongo db to quickly get some value
1 vote -
Enhancements required for SQL queries
SUPPORT Team,
PLEASE look below list of items:
1. Can you provide new feature to allow sql sub queries and correlated query like we use in oracle ?Allow me to get distinct elements of grow-able array values using SQL query, currently it is not working on array values but on regular value it is working.
Can you please provide expression function like add, subtract, multiple, sum, etc.. like we do in oracle db. This will be really helpful while aggregating data, this will simply avoid me to work on pivot tables as additional task every time.
Also need mathematical…
1 vote -
Ability to apply the same filter across multiple collection in a data compare task
I would like to be able to create a data compare and sync task that can be easily updated in one place to apply the same filter across all collections. For example, all documents in all collections have a tenantId property and so if I have a task with 100 collections I need to be able to apply the filter { "tenantId": ObjectId("5c7047fd928b3e1504eaecae") } to all of the collections without editing each one at a time.
1 vote -
Ability to edit source and target database in a data compare task
I have multiple databases that are the same schema and I perform the same data compare and sync across each of them. It would be nice to be able to create a data compare task once and then clone it and update it to point to the new DB for all collections specified instead of having to create a new task from scratch each time.
Lacking this feature in the studio 3T UI, are the tasks stored in files somewhere that I could manually edit to accomplish this?
1 vote -
Add option to execute a command before initializing SSH Tunnel
It would be great if we had an option to pre-execute a shell command before the SSH Tunnel is initialized (on ssh-tunneled connections).
This is super useful for cases where you have to do pre-auth or port-knocking before connecting to SSH hosts.1 vote -
Generate spring SPel expresion
Hello
My idea is to create a generated code to support the expression of spring.
cordially1 vote -
option for old style aggregation editor
The old editor (previous to version 2020.2), with the separation between the editor and the results tabs, made it easier to build complex aggregations (back and forth between the previous results, copying fields, etc ...).
For me the new editor is less flexible.
Could you give the possibility to choose the editing mode that suits us in the settings?
Thank you1 vote -
Remove overhead in creating bug report
If I want to issue a bug report I start Feedback from Studio 3T. Then I have to input diverse information, that Studio 3T has available in its registration data.
Name, Company, E-Mail, Version Information, Windows Version, MongoDB Version is a lot to type for every submitted issue.1 vote -
Annoying update prompt blocking app launch
Almost every time I try to open the app it blocks the launch and prompts me to update. The prompt window cannot be accessed except via alt + tab keyboard shortcuts often. This is extremely annoying. Just launch to app and prompt me afterward. Very poor user experience design.
1 vote -
Enforce password complexity rules
Currently MongoDB doesn't enforce password complexity rules (i.e Upper/Lower letters, numbers, min/max password length, special characters etc), which becomes an issue with compliance audits.
LDAP can be implemented but only on the Enterprise Licence.
Would it be possible to implement such a feature in Studio3T?
e.g.
Ensure each password meets a certain criteria when using Studio3T accessing a MongoDB database.1 vote -
Open Connections Panel : Collapse and Expand Connections and Nodes Shortcut
At one point of time I have upto 6 MongoDB Connections Open (DEV, UAT and PROD etc.)
Search works great, but it would be even better if I have following option
1. Keyboard shortcut to Expand / Collapse Selected Node (e.g. Collections/Views etc)
2. Keyboard Shortuct to Collapse all connections which will close all the expanded Connections and individual nodes (e.g. Collections.Views etc) and I get to see all 6 connections in one view without scrolling.1 vote -
Persist Visual Query Builder (open/closed) when new collection opened
Each time a new collection is opened, I wish the Visual Query Builder section would be open, or at the very least, remember whether or not I had it opened in my last collection and/or the last time I opened the same collection.
I suppose another option would be a simple setting to say whether or not you want it to be open/closed by default when a collection is opened.
(After all, there's a setting for "Auto-expand first document in tree view"... I think this would be even more useful of a setting!)
1 vote -
option to hide toolbar text.
An option to just show icons in toolbar. Display real estate is precious, but the toolbar is useful for not-yet-memorized functions.
Thanks for a most excellent MongoDB app, from utility to ease of use!
1 vote -
Generate Index script
Should be able to generate the index script by right clicking the index, which includes index name, and background = true
1 vote
- Don't see your idea?