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

Scheduled Workflows

Scheduled workflows allow you to create queries that run at regular intervals via the process server. If an event occurs that meets the conditions you specify, Vantagepoint performs an action such as sending an email alert, changing the value of a column, or initiating an activity.

Scheduled workflows are added as jobs to the process server and run according to the schedule that you set. You can specify that the workflows run on a specific date and time, or at regular intervals.

You set up scheduled workflows in Settings > Workflow > Scheduled Workflows.

Events

Each event must have at least one condition defined:
  • If the conditions of the event are not met, none of the actions for the event take place.
  • If the conditions of the event are met, Vantagepoint evaluates the conditions of each action to determine whether or not that action should take place.

You can create workflows for both standard and user-defined fields and grids. In Workflows the word column is synonymous with field.

Actions

An event can have multiple actions associated with it. For example, you can create a workflow that states that if profit percent for the current period for any organization is below 10%, then send an email message to the supervisor and set up a meeting.

SQL Expressions

Scheduled workflows, unlike user initiated workflows, allow you to build SQL expressions for events and actions, and can include calculations. You can use expressions to create events and actions when the basic Conditions fields are not enough. In addition, more elaborate date operators are available for scheduled workflows.

Multiple Companies

If you use multiple companies, additional column options and operators are available when you create the workflow. These options and operators may provide access to all companies or to the home company. See the Employees and Multicompany online help topics for more information.

Project Summary Report Fields

If you use fields from the Project Summary report in the SQL expression, you must also take one of the following actions to prevent unexpected results:

  • Refresh the Project Summary tables just before the scheduled workflow is to run.
  • Include in the SQL expression a case statement that accounts for projects added since the Project Summary tables were last refreshed. The case statement must specify that if a row is not in the Project Summary table for a project (because the table has not been refreshed since that project was added to the database), then use a value that you specify, such as zero.