Skip to main content
Mitratech Success Center

Using T-SQL with Custom Tasks

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.

  • Was this article helpful?