Use the Stored Procedure dialog box to execute a stored procedure on the PM Compass database and Create a Stored Procedure action for a Workflow.
You can execute custom SQLs against the PM Compass database without having to write code to deploy via the Invoke Custom Method option.
For more information, see Stored Procedure Overview.
Enter the name of the stored procedure. The arguments for the stored procedure appear in the Arguments grid.
This grid is the list of arguments that will be used when the stored procedure is executed. The contents of the grid depends on the stored procedure selected and reloaded when the stored procedure text box is changed.
Option |
Description |
Arguments |
Select the following options from the drop-down list:
|
Field Name |
Description |
Name |
Use this column to view the argument name |
Value |
Use this column to input the value of the argument or parameter. The SQL expression, which will be used to determine the value of the argument at run time. Click |
Select this option if you want the record that the user was working on when the workflow fired to be reloaded. You should select this field if the stored procedure being invoked alters the current record. This allows you to see the record with whatever changes the stored procedure made.
If you select this option, the action will run after the entire Info Center record (including all grids) has been saved. Otherwise, the action will run after the main workflow table has been saved, but before any of the grid tables have been processed. (The later is the current and default behavior.)
This option is only available when the workflow is on the main workflow table, for example, [Employee Record].
Click this button to save your settings and close the dialog box.
Click this button to close the dialog box without saving your settings.
Click this button to view the Help for this topic.
to display the