In this article, you will read about table actions in TimeXtender MDM. Table Actions provide the user with a simple way to store frequently used scripts or procedures relevant to the table. These scripts can then be executed by anyone editing the table data. Commonly used Actions are row validations, browser shortcuts and pushing data from MDM to other systems.

Create and Remove Actions

1. To create an Action open the Table Designer
2. Press the “Edit Action” button

   

3. Inside the Actions form, you can simply Add actions by clicking the add button
4. Or Remove Actions by clicking the remove button
5. Or see a List containing all your Actions

Action Types

There are five types of Actions available:

• SQL Task: This allows users to execute SQL queries or stored procedures. A common use of this action is to validate the data that just got changed. To learn more about SQL Tasks read the SQL Task Actions in TimeXtender MDM article.
• Execute Command: This allows the user to open an email or browser. This can be used to open an underlying system with row values as parameters.
• Execute PowerShell: This allows the user to execute a PowerShell script.
• Publish Data: This allows users to move edited data from TimeXtender MDM to an underlying source. To learn more about Publish Data actions read the Publish Data to External Database, from MDM article.
• Execute in TimeXtender O&DQ: This allows the user to execute an item (e.g. queries, packages) in TimeXtender DQ. To learn more about TimeXtender DQ actions read the TimeXtender DQ Actions in TimeXtender MDM article.

Shared Customizable Features

All action types have a few shared customizable features. These include display DB name, exec options tab and the display options tab.

Display- & Database Name

1. Display Name: If you choose to make your Action visible in the Table Editor this is the name that will appear on the Action there.
2. Database Name: This name will be stored as the Action name in the Database.

Exec Options Tab

1. Automatically run when Saving Data: Check this box if you would like your Action to run every time you save your data in the Table Editor.
2. Save Data before Execution: Check this box if you would like the Table Editor to save the grid changes before the Action is executed.
3. Refresh Data after Execution: Check this box if you would like your data to be refreshed after the Action has been executed to see the changes.

Display Options Tab

1. Description: Add a description of your Action. This description will also be visible in the Actions tooltip in the Table Editor Toolbar.
2. Icon: If you choose to have your Action visible in either the Context Menu or Toolbar this Icon will appear next to the Actions' Display name.
3. Visible in the Context Menu: Check this box if you would like your Action to be visible in the Table Editor's Context Menu (right-click a row to see the Context Menu).
   • This option allows the user to select one or many rows and right-click to execute the Action.
   • When executing the action this way, IDs of selected rows can be used by the action to e.g. validate only the selected rows.
4. Visible in Toolbar: Check this box if you would like your Action to be visible in the Table Editor's Toolbar.