Versions Compared

Key

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

...

Code Block
do ( 
	// First build up the filter 
	$filter = andCondition[], 
	$filter = addElement($filter, fieldCondition("productId", _EQUALS, in.productId) ), 
	$filter = addElement($filter, fieldCondition("productStatus", _EQUALS, "OK" )), 

	// set the filter on the Pipe 
	setFilter( prodLookup, $filter ), 
	
	// now lookup on the pipe lookup (prodLookup), 
	$prodName = prodLookup.name 
)

do ( // First build up the filter $filter = andCondition(), $filter = addElement($filter, fieldCondition("productId", _EQUALS, in.productId) ), $filter = addElement($filter, fieldCondition("productStatus", _EQUALS, "OK" )), // set the filter on the Pipe setFilter( prodLookup, $filter ), // now lookup on the pipe lookup (prodLookup), $prodName = prodLookup.name )

This example creates an AND clause which specifies that the Attribute productId must equal the value currently held in in.productId AND the productStatus Attribute in the target Pipe must equal "OK". The filter is then assigned to the Pipe prodLookup and a lookup is performed by invoking the lookup() function.

Note that you can add as many Pipe Filter Conditions as you need to the AND Pipe Filter Clause.


Nested Example

Code Block
do(
	$filter = andCondition(), 
	$filter = addElement($filter, fieldCondition("productId", _EQUALS, in.productId)), 
	$filter = addElement($filter, fieldCondition("productStatus", _EQUALS, "OK")), 
	$filter = addElement($filter, fieldCondition("productClass", _EQUALS, "RETAIL" )), 
	....

...


)

Clauses can also be nested:

...


do(
	$statusCond = andCondition(), 
	$statusCond = addElement($statusCond, fieldCondition("productStatus", _EQUALS, "GOOD" )), 
	$filter 	= andCondition(), 
	$filter 	= addElement($filter, fieldCondition("productId", _EQUALS, in.productId) ), 
	$filter 	= addElement($filter, $statusCond), 
	....
)


See Also