Creating Filters for a Child Entity of a Conceptual Object
You can specify filter criteria for the child objects in a conceptual object. The syntax to create a child filter in a deep link URL is as follows:
filter=<Parent Object Name>.<Child Object Name>.<ColumnName>=[value]
Note: For the child filter in a deep link to work properly, do not select a Default Child Filter in the object definition.
When child filter criterion is specified in the deep link, the Filter screen displays the child filter as a text box where the user can add further criteria for the child objects. You cannot change the logical operator used in the text field for child filter.
Note: Clicking Clear Filter removes the text box for the child filter. You user can then select a new filter for the child object and specify new filter criteria.
For example, the conceptual object Location contains the objects Country, State, and City. The child object, City, can be accessed two ways: Country > State > City and Country > City.
If you use different object paths in the filter, you can only specify an and condition, as in the following example:
Country.State.City.City_ID=10012 and Country.City.City_Name="City 1"
Whereas, if you specify the same object path in the filter, you can use an and or an or condition, for example:
Country.State.City.City_ID=10012 and Country.State.City.City_Name=”City 1"
Country.State.City.City_ID=10012 or Country.State.City.City_Name=”City 1"
