Initialize workflow

You can use a query to set the value of a workflow attribute.

A query is used if the value cannot directly be retrieved from an ERP table field.

For example you can:

  • You can calculate the total amount of an order
  • You can retrieve information from another table based on the value in an ERP table field.
General

The query can retrieve:

  • A specific value of an ERP table field (ENtgwms.sqlf.value)
  • The lowest value of an ERP table field (ENtgwms.sqlf.minimum)
  • The highest value of an ERP table field (ENtgwms.sqlf.maximum)
  • The sum of an ERP table field (ENtgwms.sqlf.sum)
  • The average of an ERP table (ENtgwms.sqlf.average)
  • The number of occurrences of an ERP table field (ENtgwms.sqlf.count)
Note

The text in parenthesis is the Query Function you must use to accomplish the task mentioned.

Based on the query field conditions, the range of records is determined that the query will work upon.

To create a query

To create a new query, you need to start the Queries (tgwms1560m000) session.

  • Click New.

Specify a query name and give a short description of its function.

Double-click this query and specify the Query Function and the ERP table field name whose value will be used to fill the workflow attribute at run time.

Next, specify the query conditions by selecting the Query Field Conditions command on the appropriate menu. The total condition (WHERE clause) can consist of individual conditions and are connected by a logical AND.

Choose the Check Query Syntax command on the appropriate menu to check the syntax of the query. A dialog box shows the error messages.

Choose the Evaluate Query command on the appropriate menu to test the query (which only works if the Query Syntax is correct). As a result, the query is displayed in a SELECT, FROM, and WHERE format, together with the outcome of the evaluation.

If the evaluation is ok you can use the query to set a workflow attribute's value.

Where you can use a query

A query can be linked to a workflow attribute (binding).

To bind a query to a workflow attribute: