Skip to main content

SQL Task Actions in TimeXtender Master Data Management


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

In this article, you will read about creating SQL task actions in TimeXtender Master Data Management. A SQL task action is a versatile way to make it easier to work with table data. Actions can be used to validate, backup or modify data. They can also be added as a button in the editing area or programmed automatically execute when the table is saved.

Create your first action

Here are steps to create a basic validation action:

  1. Open the table you want to validate in TimeXtender Master Data Management. Click on Table Designer in the navigation ribbon.
  2. Click Actions.
  3. Select the Add dropdown and click on SQL Task.
  4. Display name: Demo SQL Task
  5. DB Name: Demo DB (or your preferred Database name)
  6. Set the SQL query to:
    update %TableName%  
    set __ValidationError = NULL
    
    update %TableName%  
    set __ValidationError = 'Below 100.000'  
    where [Price] < 100000  
  7. Next, click the Execution tab
  8. Check Automatically run when saving data
  9. Selecting In Parameters allows the user to send custom parameters to the action.
  10. Click Run Action if you want to validate your data immediately.
  11. Click Save Tasks to save your action.
Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings