Versions Compared

Old Version 6

changes.mady.by.user Izabela Bogorska

Saved on

compared with

New Version Current

changes.mady.by.user Tomasz Mackowski

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

USE: 

Selection criteria are used to fetch relevant records from tables specified in the previous step.  For each table, it must be specified how the rows should be selected based on values stored in variables or fetched from records from preceding steps. Technically the configuration is used to prepare WHERE conditions for database queries. The queries that will be generated will be used to fetch references and newly created documents.

PROCEDURE:

  1. For edited configuration object, select step in the DB Comparision rules screen:
  2. Double click on Selection Criteria
  3. Add selection criteria to the particular table selected in step 1.

...

Parameter NameDescription
Field nameName of database field from database table defined for the step or one of the joined tables.
Select Options

SQL Comparison Operator based on the list:

= Equal
<> Not Equal
CS Contains String
SW Starts with
EW Ends with
> Greater
>= Greater or equal
< Less
<= Less or equal
IN In operator (can be used with reference type 'constant' and comma separated values)

Reference Type

Type of value used for comparison.
Available types:

  • variable - used to reference values from object variables
  • constant - constant value
  • DB reference - used to reference field from parent step to form parent-child relation
Reference Value

Reference value depending on Reference Type.

  • type = variable - name of the variable
  • type = constant - expected value 
  • type = DB reference - name of the field in the parent database table
+ 

(optional) SQL Logical operator used in case of multiple criteria are defined for the table.

Available options:

  • AND
  • OR

which means if the criteria should be considered together or separately

...

SELECT * FROM VBAK WHERE BSTNK = value from PO_ORDER_NUBER, for example 'PO123'.

Example 2. We would like to fetch all order items for headers that were fetched in the first example.

The tables representing business document (The DB comparison rules screen):

...