The Designer Panel

This is your middle panel. This is what you will use to setup the collection configuration and build your aggregation pipeline stages.

Collection Configuration

From adding a Title through the toggle switches and creating identifiers, they all work exactly the same way as they do with the data-in Collection parameters. Please refer to section 1.1 for more details here.

Transform Stages

The transform stages section allows you to add multiple aggregation steps together to create your transformation pipeline. For those users familiar with mongoDB aggregation pipelines you can simply add a JSON stage with your pipeline, and you are done. For those who are unfamiliar with the mongoDB syntax, we have created some basic for user friendly stages to help you build your pipeline.

Transform Stage Management

Create a stage, simply press the “+” button.

Delete a stage: Press the red trash can button.

Edit a stage: Press the pencil button.

Turn a stage off in the designer: press the blue toggle button. *Note: even if this is turned off, if you save the document the aggregation will be saved as if the stage is on.

To refresh the aggregation: press the refresh button on the “Transform Stages” block.

To identify a problem with the aggregation: If there is an error with the aggregation pipeline, the “save” button on the bottom right will turn from green to red. Details on the error can be found in the Elmah logs (details on this in another section)

You can re-order stages simply by dragging and dropping them