EXTRACT

Use EXTRACT whenever you need only particular members of a series returned-those that meet a certain condition. An example might be only POs that contain back-ordered items.

The EXTRACT function can only be used in a map rule. It cannot be used in a component rule.

The EXTRACT function returns all members of a series for which a specified condition is true.

Syntax:
EXTRACT (series-object-expression, single-condition-expression)
Meaning:
EXTRACT (objects_to_extract, condition_to_evaluate)
Returns:
A series object.

The result is each member of series_to_search for which the condition specified by condition_to_evaluate evaluates to "true". EXTRACT returns "none", if no member of series_to_search has a corresponding condition_to_evaluate that evaluates to "true".

Examples

  • EXTRACT ( PO:Transaction , Store# = Location:PO:Transaction )

    This example returns all POs, individually, whose Location is a particular Store#.

  • EXTRACT ( Row:DBSelect , ProcessFlag Column:Row:DBSelect = "Y" )

    This example returns all Rows that have a ProcessFlag Column value of "Y".

Related Functions

  • CHOOSE
  • LOOKUP
  • SEARCHDOWN
  • SEARCHUP

Feedback