Page History

Workflow scripts allow you perform actions programmatically on one or multiple objects within RED. For example, you can create a workflow script that exports the DDL for one or multiple objects or for performing GIT operations like Check-in or Check-out on a set of objects. You can launch scripts from the context menu of one or multiple selected objects.

...

1. Create a language type called ps workflow
   1. Set the file extension to ps1
   2. Set the command to PowerShell -ExecutionPolicy Bypass -File "$SCRIPT_NAME$"
   3. Set the category field to Workflow.
   4. Click OK.
      
      
2. Add a new Metadata Object Type.
   1. To add a new object, right click on the Host Script node.
   2. Select New Object.
   3. For this example, enter Print Context as a name.
   4. Click OK.
      
      
3. In the configuration window, set the type to ps workflow script, set the appropriate Owner and Connection Name for your data.
   
   
4. The new script should appear on the Host Script node.
   
5. Right click on Print Context and select Edit the Script. This will open the script on a new tab.
6. On the edit script tab enter the following code:
   

   Code Block
   collapse language powershell true
   write-output 1 write-output 'Printing context' # print the expected context file write-output "---- First 20 lines of context file: `n$PSScriptRoot\wsla${ENV:WSL_SEQUENCE}.objects`n----" if (Test-Path -path "$PSScriptRoot\wsla${ENV:WSL_SEQUENCE}.objects") {     get-content -path "$PSScriptRoot\wsla${ENV:WSL_SEQUENCE}.objects" -TotalCount 20 | write-output } else {   write-output "*** Error: Objects file doesn't exist as there were no objects in the current context. ***" }

...