Conceptual Object Filters
You can create a deep link filter for conceptual objects, which are logical or virtual relationships between objects. Like filtering in data objects, you can use logical operators to search for records that match the data in multiple columns. The following restrictions apply when filtering records in conceptual objects:
Same object filter: Either
or or
and operators are valid in filters among different columns within the
same object.
Different object filter: Only
and operators are valid in filters between
different objects.
Single operator restriction: Only one type of operator may be used in a filter; either an
or or an
and condition can be used, but not both.
The following table provides examples of valid and invalid filters on conceptual objects. In this example, Object1 and Object2 are part of the same conceptual object hierarchy.
Filter Specified | Valid? |
Object1.Col1=1 and Object2.Col2=2 | Yes. You can only create an and condition between objects. |
Object1.Col1=1 or Object2.Col2=2 | No. You cannot use an or condition between objects. |
Object1.Col1=1 or Object1.Col2=2 or Object2.Col3=3 | No. The first or is valid because it is among the columns of the same object. However, the second or condition is invalid because it is between different objects and only an and condition can be specified between different objects. The following filter is also invalid because it mixes or and and operators in the same filter, even though the right operator (and) is used between objects: Object1.Col1=1 or Object1.Col2=2 and Object2.Col3=3 |