Filter

Optionally, use this field to view, specify, and edit the IDO filter you want to use during validation.

This filter eventually becomes the WHERE clause for the query that returns the valid values.

For example, suppose you have an IDO named Orders and it has OrderNumber and OrderStatus properties. You want to make an In Collection validator that will check to see if an OrderNumber exists AND if the OrderStatus is OPEN.

If you specify the IDO name (Orders) and the IDO property (OrderNumber), that is sufficient to determine whether the order number is valid. However, to figure out whether the status is OPEN, you would need a filter to restrict the set of valid all valid OrderNumbers to just those whose status is OPEN. In that case, use this filter: OrderStatus = 'OPEN'