Read from NoSQL DB

Select the required database connection from the dropdown list. The options displayed are based on the connections defined in Spectrum Management Console.

To add a new connection, see Connecting to NoSQL.

To modify an existing connection, select and open it from the list of connections on the Connections page of Spectrum Management Console, make the required updates, and click the Save button.

To clear the selected file path, click Clear.

This syntax is for a clause with an equal to operator:

{"<column name>" : "<filter value>"}

You can join multiple clauses using the required operators. For a list of the supported operators in the where clause, see http://docs.mongodb.org/manual/reference/operator/query/.

For example, to fetch records where the value of the column customer_name matches the value John, and the value of the column customer_age is greater than or equal to 45, enter the below:

{$and: [{"customer_name": "John"}, {$gte: ["customer_age","45"]}]}