Input
The following table describes the fields in the Input tab of the QueryDocument activity.
Input Item | Data Type | Description |
---|---|---|
The following fields are displayed when FIND_ONE in the Query Type list is selected in the General tab. | ||
CollectionName | String | Specify the name for the collection, where query operations are performed, with single or double quotation marks. |
QueryDocument | String | Enter a document with double quotation marks. This document is used to query one or more documents from a specified collection. |
ReturnFieldsDocument | String | Enter a document with double quotation marks. This document is used to decide the return field values in the queried documents. |
SortDocument | String | Enter a document with double quotation marks. This document is used to define the display order of the documents in the query result. |
The following fields are displayed when FIND_MANY in the Query Type list is selected in the General tab. | ||
CollectionName | String | Specify the name for the collection, where query operations are performed, with single or double quotation marks. |
QueryDocument | String | Enter a document with double quotation marks. This document is used to query one or more documents from a specified collection. |
ReturnFieldsDocument | String | Enter a document with double quotation marks. This document is used to decide the return field values in the queried documents. |
Skip | Integer | Enter a number to decide how many documents to skip before the query result is displayed. |
Limit | Integer | Enter a number to decide how many documents to display as the query result. |
HintDocument | String | Enter a document with double quotation marks. This document contains an index name or index specification and is used to overwrite the default index in a collection. |
SortDocument | Integer | Enter a document with double quotation marks. This document is used to define the display order of the documents in the query result. |
The following fields are displayed when COUNT in the Query Type list is selected in the General tab. | ||
CollectionName | String | Specify the name for the collection, where query operations are performed, with single or double quotation marks. |
QueryDocument | String | Enter a document with double quotation marks. This document is used to query one or more documents from a specified collection. |
Skip | Integer | Enter a number to decide how many documents to skip before the query result is displayed. |
Limit | Integer | Enter a number to decide how many documents to display as the query result. |
The following fields are displayed when DISTINCT in the Query Type list is selected in the General tab. | ||
CollectionName | String | Specify the name for the collection, where query operations are performed, with single or double quotation marks. |
QueryDocument | String | Enter a document with double quotation marks. This document is used to query one or more documents from a specified collection. |
DistinctField | String | Enter a field name with single or double quotation marks. This document decides the distinct field values returned from the queried documents. |
The following fields are displayed when Aggregate in the Query Type list is selected in the General tab. | ||
CollectionName | String | Specify the name for the collection, where query operations are performed, with single or double quotation marks. |
Document | String | Enter a document with double quotation marks. This document contains an aggregation pipeline or a map-reduce operation and is used to perform an aggregation in a collection.
For more information on defining an aggregation pipeline or a map-reduce operation, refer to http://docs.mongodb.org/manual/core/aggregation-introduction. |
The following fields are displayed when the Is GridFS check box, and FIND_ONE in the File Query Type list are selected in the General tab. | ||
BucketName | String | Enter the name for the bucket, where you can query one matching file, with single or double quotation marks. |
FileName | String | Enter the name for the file with single or double quotation marks. |
GenerateNewFile | String | Enter the absolute path for the file, where you want to save the query output result, with double quotation marks. Available only when WRITE_TO_FILE in the File Content Output Type list is selected in the General tab. |
The following fields are displayed when the Is GridFS check box, and FIND_MANY in the File Query Type list are selected in the General tab. | ||
BucketName | String | Enter the name for the bucket, where you can query all matching files, with single or double quotation marks. |
QueryDocument | String | Enter a document with double quotation marks. This document is used to query files from a bucket. |
OutputFileDirectory | String | Enter the directory for the output file with single or double quotation marks. Available only when WRITE_TO_FILE in the File Content Output Type list is selected in the General tab. |
Copyright © Cloud Software Group, Inc. All rights reserved.