Common Filter

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 25, 2024 by Kinga Huszno
1 min read

Common filter limits the number of rows in the output data. This filter is used in all Objects. It has only one parameter - “maxrows”.

The default value of this parameter is 100.000 records (500.000 for “Earn Thru Rule”).

This filter is always applied.  If you want to keep the default value of 100,000 records you do not need to anything. If you want to change the default value, you will need to include the maxrows parameter and value.

CustomWhere is a part of common filter, but is considered a customization and thus is described in the Custom Filters page.

Example: Common Filter

<taskParameter>     <name>maxrows</name>     <dataType>S</dataType>     <value>1000</value> </taskParameter>

For one-to-many relationship objects (Contractual Cash Settlement Rule, Earn Thru Rule, etc.) this filter limits the number of child elements.