Several custom task types, such as the Database Connector Custom Tasks, allow you to use T-SQL to pass SQL statements directly to the Process Director database.
Process Director implements some custom methods for using system variables in SQL statements, such as
- Encode types for Strings ($), numbers (#), and string handling for use in LIKE clauses (~).
- Pre, Post, and Null text operators for System Variables
- Pattern, Replace, and Trim for use with Regular Expressions
All of these items are documented in the System Variables Guide at the topics linked above in the list.