EBIworld.com > EBI/Clarify Tips > Complex AND/OR Data Binding Selection Example

Complex AND/OR Data Binding Selection Example

TAGS: EXTOL Bindings / EXTOL JD Edwards /

We have the business requirements to select JDEdwards database data. This criteria is critical in order for us to create an outbound EDI document.

SCENARIO:

Our selection criteria is:

SYPNID LIKE ‘LB%’
OR
SYPNID LIKE 'TE%’
AND
SYEDSP = ’ ’ OR 'N’ OR 'R’

DATABASE BINDING SET-UP:

The AND/OR logic is applied to the child nodes of its own group.


By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.