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.
Note: The value specified in this field overwrites the value specified in the Collection Name field in the General tab.
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.
Note: The value specified in this field overwrites the value specified in the Collection Name field in the General tab.
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.
Note: The value specified in this field overwrites the value specified in the Collection Name field in the General tab.
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.
Note: The value specified in this field overwrites the value specified in the Collection Name field in the General tab.
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.
Note: The value specified in this field overwrites the value specified in the Collection Name field in the General tab.
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.