Updated on 2023-03-07 GMT+08:00

Command Window

Procedure

  1. On the top menu bar, choose Command Operation > Command Window.
  2. In the displayed text box, enter the commands you want to execute and click Execute Command.
  3. In the lower part of the page, view the execution results.

    • On the Executed Commands tab page, view the details about the commands that have been executed.
    • On the Messages tab page, view the execution results (successful or failed) and execution duration of current commands.
    • Currently, the db.collection.aggregate() command is not supported. You can run the db.runCommand command instead. The following is an example about how to use syntax:
      db.runCommand({
      	aggregate: "collection",
      	pipeline: [{
      			"$match": {
      				"time": {
      					"$gte": 20.0
      				}
      			}
      		},
      		{
      			"$sort": {
      				"time": -1.0
      			}
      		}
      	]
      });
    • You can execute SQL commands in either of the following ways:
      • 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.