Using the ## and # symbols

You can use ## symbols in workflow actions to add information from the related entity or the user table.

  • You can use ## symbols in the JavaScript Conditions of primary, transition, conditional, and global rules, and the Trigger SQL Clause of escalation rules to define conditions. When you use ## symbols in a condition or statement, actual database values are substituted when the metadata is parsed. For example, the following SQL statement compares the actual Campaign Wave Activity ID with the value in a Communications Wave Activity field.
    Update Communication set Comm_
    Deleted=1 where Comm_
    WaveItemId=#WaIt_WaveItemId#
  • If you use ## symbols in the body of an email, SMS, onscreen message, or notification, the translations are used.
  • You can use the # symbol before certain letters to run internal function calls that return a concrete value. For example, the following script uses #T and #U to compare the current time and user with the values of fields containing escalation information.
    Escl_DateTime<#T And Escl_
    UserID=#U AND Upper(RTRIM
    (comm_status))=N'PENDING'

    Code

    Returned value

    #U

    Current logged on user as an ID.

    #L

    Current logged on user as a string.

    #C

    Current logged on team as an ID.

    #D

    Current logged on team as a string.

    #T

    Current time.

    #R

    Recent list information.

    #O

    Current opportunity ID.