You can use the MongoDB adapter to interact with a MongoDB and to insert, get and manipulate documents.

Using one of the find operations from the MongoDB adapter, you can retrieve data. MongoDB stores data in form of documents that are depicted in a JSON-like format. Queries always return one or more complete documents.

{
  "id": "ebd7c78b-44e0-4cbd-8164-d28431716942"
            
  "name": "John Snow",
  "company": "Winter & Partners",
  "address": {
    "street": "99, Malamute Street",
    "city": "Anchorage, AK 99506",
    "country:": "USA"
  },
  orderValue: "16323.00
}

The MongoDB adapter comes with three find operations: two returning the result set in different formats, one returning a handle to the result set.

Refer to the reference of find operations and fetch operations for a detailed description of all parameters and options.

Selecting Output Data

MongoDB uses the concept of "projection" to define which properties should be selected from a document. The projection is supplied to the adapter call via the projection attribute of the MongoDBFindOptions.

The following rules apply to projections:

Sorting

You can sort the document list you get back from an adapter call by providing the sort attribute of MongoDBFindOptions. Parameter sort contains the document properties to sort by. Value 1 is ascending sorting, value -1 is descending sorting. The order of JSON properties reflects the sort hierarchy.

create options;
set options.`sort` = "'{"company":1,"orderVolume":-1}';

You can also create a class defining the sort options, and use classToExtendedJSON() to create the sort string.

Using Regular Expressions

You can use regular expressions to find MongoDB documents in a LIKE fashion. This can be done using the MongoDB operator $regex.

Generally, you can do this using the same three steps as described above with querying documents:

1. Create an object having the structure of the document you want to query.
   In this case, you want to use the regex operator and apply it to a document property. In the example, this is the name property of the Customer object. Create a structure like the following:

   

2. Set the query values to this object, e.g. as in the example using Action Script, where queryData is an object of RegExCustomer:

   Code Block
   create queryData; set queryData.name.regexOperator = concat(".*\Q", customerName, "\E.*") if customerName.exists() and customerName != "";

3. Provide this object as queryString by converting it to JSON using classToExtendedJSON().

   Code Block
   set queryString = queryData.classToExtendedJSON();

Security Considerations

This also applies to building the regex operator in the example above. A maleficent user could use the variable part of the regex customerName to inject regex syntax.