filter

Description Syntax Parameters Returns Example
Filters a list of records. filter(records, selectionCriteria) records: array of records.

selectionCriteria: WHERE Clause.

Array of records that match filter criteria. filter(CHILD_RECORDS, where [PERISHABLE = 'YES' and DD = 'X'])

<op func="filter">

<var>CHILD_RECORD_LIST</var>

<condition> <and>

<eq>

<var>EFFECTIVE_DATE</var>

<var>ROOT/EFFECTIVE_DATE</var>

</eq>

</and>

</condition>

</op>

Filters relationship attributes. filter_relationshiprecords(relationships, selectionCriteria) relationship: array of relationships.

selectionCriteria: WHERE Clause.

Array of relationship that match filter criteria. filter_relationshiprecord(ccr_relationship, where ( AddressType = 'Y' )))

<op func="filter_relationshiprecord"> <var>ccr_relationship</var> <condition> <eq> <var>AddressType</var> <const type="string">Y</const>

</eq> </condition> </op>