Skip to content

SQL Tool

Form Fields

  • Tool Name - The name of the tool.

  • Icon - The icon used when viewing the list of available tools.

  • SQL - The entire SQL query that will be executed when the tool is selected.

  • Journal - A checkbox to control whether or not a journal entry is added to the event when the tool is used.

  • Entry - The journal entry that will be added when the tool is used.

Best Practices

  • When the SQL command is executed, the following tokens will be replaced in SQL field:

    • $USERNAME - User name of the user executing tool.

    • $EVENTLIST - Comma delimited list of the selected Event IDs.

  • When the journal is written, the following tokens will be replaced in the Entry field:

    • $USERID - UserID of the user executing tool.

    • $USERNAME - User name of the user executing tool.

    • $USERFULLNAME - Full name of the user executing tool.

    • $USERGROUPID - User Group ID of the user executing tool.

Back