Macro Repository

NLS 5.39 and later

Global SQL statements can be stored in the Macro Repository and accessed using its identifier from other areas of NLS.

Macro Repository

Click Add to create a new macro.

Add dialog

Field Comment
Identifier By default, a unique identifier is generated by NLS but you may specify your own identifier. The identifier cannot be changed once a macro is created.
Category Communication - for use in the email and SMS templates in communication settings.
DocuSign - Reserved.Web SQL - Reserved.
Description Description of the macro for your reference.

Once a new entry is created, enter the SQL statement in the Macro Value field.



Accessing Macros

To access macros in the repository, use {NLS_SQL_MACRO_GUID} to specify the macro where GUID is the identifier of the macro.

Example

Place a loan’s open date and loan number into an email’s body: 
<html>
    <p>open date: {NLS_SQL_MACRO_8C70E83187}</p>
    <p>loan number: {NLS_SQL_MACRO_E88FBE36F3}</p>
</html>