Custom macros

A custom macro is a query that you create using an IBM® Expression, raw SQL, or raw SQL that includes a value. Custom macros support the use of variables.

You can save a custom macro so it is available when configuring processes in a flowchart and defining derived fields.

Support for raw SQL improves performance, allowing complex transactions to be carried out in the database rather than having the raw data filtered and manipulated in the application server.

Campaign supports the following types of custom macros, which in turn support an unlimited number of variables:

Custom macros that use a IBM Expression
Custom macros that use raw SQL
Custom macros that use raw SQL and include a specified value

Important: Since non-technical users are able to use custom macros, when you create a custom macro you should describe how it works very carefully, place similar kinds of macros in special folders, and so on. This approach can help reduce the possibility that someone might use a custom macro incorrectly and retrieve data that they were not expecting.