Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Create a Stored Procedure Action

Use this action to execute a stored procedure on the Vantagepoint database. You can execute custom SQLs against the Vantagepoint database without having to write code to deploy via the Invoke Custom Method. You can create these actions for user initiated workflows or scheduled workflows.

This action requires that users know SQL and know how to write stored procedures.

To create a stored procedure action:

  1. In the Navigation pane, select Settings > Workflow > User Initiated Workflows or select Settings > Workflow > Scheduled Workflows.
  2. On the User Initiated Workflows form or Scheduled Workflows form, use the drop-down list in the header field to select the hub or other area, such as employees or billing terms.
  3. In the Workflows grid (or Scheduled Workflows grid), select the workflow row (event) to which you want to add the action.
  4. In the Actions grid, click Add Action > Stored Procedure.
  5. In the Stored Procedure field on the Stored Procedure Configuration dialog box, enter a descriptive name for the procedure.
  6. Under Arguments, set name-value pairs for each argument in the stored procedure.
  7. If the stored procedure will alter the record that the user is currently working on, select the Reload Info Center Record option to have that record redisplay when the procedure completes.
  8. If the stored procedure should be called only after all the user's changes are saved, select the Invoke after all changes are saved option.
    If you do not select this option, the action runs after the main workflow table has been saved, but before any of the grid tables have been processed.
  9. Click Save.
    The action that you created is now listed in the Actions grid of the User Initiated Workflows form or Scheduled Workflows form.