General

The following table describes the fields on the General tab of the QueryDocument activity.

Field Module Property ? Description
Name No The name of the activity displayed in the process.

Default value: QueryDocument

MongoDB Connection Yes Select a shared resource by completing the following steps:
  1. Click the Choose/Create Default Resource icon to open the Select MongodbconnectionResource Resource Template dialog box, which lists all the available resources.
  2. In the Matching items panel, select a shared resource and click OK.
Collection Name Yes Specify the name for the collection where documents are queried. Adhere to the following rules when specifying the collection name:
  • Do not start the collection name with system.
  • Do not contain empty strings, and characters such as $.

Condition: Available when Is GridFs is unchecked.

Query Type Yes Specify the query type that you want to use. The following options are available:
  • FIND_ONE

    Finds the first document that matches the query condition.

  • FIND_MANY

    Finds all documents that match the query condition.

  • COUNT

    Counts the total number of documents that match the query condition.

  • DISTINCT

    Finds an array of distinct values for a specified field in documents.

  • AGGREGATE

    Processes documents in a collection by using versatile stage-based data processing pipeline or map-reduce operations.

Condition: Available when Is GridFs is unchecked.

Read Preference Yes Select the read preference when the plug-in queries documents from a collection. The following options are available:
  • PRIMARY

    Reads from the primary member of a replica set.

  • PRIMARY_PREFERRED

    Reads from the primary member preferentially, but if the primary member is unavailable, reads from secondary members of a replica set.

  • SECONDARY

    Reads from secondary members of a replica set.

  • SECONDARY_PREFERRED

    Reads from secondary members preferentially, but if no secondary members are available, reads from the primary member of a replica set.

  • NEAREST

    Reads from a member of a replica set with the least network latency, irrespective of the member type of the replica set.

Note: The query preference functionality does not support the aggregate query type. When you select AGGREGATE from the Query Type list, the Read Preference list is unavailable.

Read Preference selected for the first acitivity inside transaction group is used as transaction level read preference.All QueryDocument activities are executed using that read preference ignoring the read preference selected for the remaining QueryDocument activities inside the transaction group.

Condition: Available when Is GridFs is unchecked.

Is GridFS Yes Select this check box if you want to query one or more files from a bucket.
Note: GridFS is a specification for storing and retrieving files that exceed the BSON-document size limit of 16 MB.

This option is not supported by the local transactions.

File Query Type Yes Select a file query type from the following list:
  • FIND_ONE

    Finds the first file that matches the query condition.

  • FIND_MANY

    Finds all files that match the query condition.

Condition: Available only when the Is GridFS check box is selected

File Content Output Type Yes Select an output type for a file from the following list:
  • JAVA_OBJECT

    Produces an object that contains the returned file content as the output.

  • BINARY

    Produces a byte array as the output.

  • WRITE_TO_FILE

    Creates a new file that contains the returned file content.

Condition: Available only when the Is GridFS check box is selected