Command Query
DAS manages database collections and views through SQL statements, facilitating user operations.
Precautions
db.runCommand({ aggregate: "collection", pipeline: [{ "$match": { "time": { "$gte": 20.0 } } }, { "$sort": { "time": -1.0 } } ] });
Procedure
- Log in to the management console.
- Click in the upper left corner and select a region and project.
- Click in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
You can also click Go to Development Tool on the overview page.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Command Operation > Command Window.
- In the displayed text box, enter the commands you want to execute and click Execute Command.
Figure 1 Executing a command
You can also perform the operations listed in Table 1 on the command query page.
Table 1 Function description Function
Description
Executing Command
Executes commands.
Commands are performed on collections and views in a database.
Full Screen
Shows commands on a full screen.
Save Executed Commands
After this function is enabled, the system saves the recently executed commands to the server.
Executed Commands
Shows the command execution details.
Messages
Shows the command output.
Result Set
Shows the command execution result.
Overwrite/Append Mode
- Append Mode: Each time a command is executed, the new result set is appended to the previous one.
- Overwrite Mode: Each time a command is executed, the new result set overwrites the previous one.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot