When you execute Select
steps, the system provides you with a powerful search tool that allows you to find nodes using different attributes as the search criteria.
When you first specify a Select [node]
operation, the Select [node]
assignment block displays the selection criteria that correspond to the node's main attributes.
Example
If you specify a Select IPs
operation, the Select IP
assignment block allows you to use header data as the selection criteria (such as ID, description, status, or generation formula).
When the system displays attributes in the Select [node]
assignment block, the search attributes are grouped by node, with the name of the node displayed at the top of the attribute list. By default, the main node attributes are displayed first.
You can search by different attributes by selecting a different node. To do so, select the Open Input Help
button next to the node name and select a new node in the Value Help dialog box.
You can search by multiple attributes to better filter the search results.
The system provides you with multiple selection fields in which you can enter the search criteria. However, you can add additional fields by selecting the Copy Line
button next to a field).
Example
You can search for IPs with a description containing the word “Book” (IP Description
attribute set to “*book*”) or you can search for IPs with the description containing the word “Book” and a publication date set to 2005 or later (IP Description
attribute
set to “*book” and Publication Date
attribute set to January 1, 2005 or greater)
Note
If you wish to search by multiple attributes that belong to different nodes, select the Add Node
button, next to the node name. When the value help dialog box appears, select a node that contains the attribute you wish to include as your selection criteria.
Note
When you specify multiple values for the same search attribute, the system unites the search criteria (for example value 1 OR value 2.)
When you specify values for different search attributes, the system intersects the search criteria (for example value 1 AND value 2).
Example
In the Select IP Header
assignment block, you specify the following:
IP ID starts with “3”
IP ID starts with “5”
IP Description is “Movie Screenplay”
The software interprets this setting as follows: (IP ID starts with “3” OR IP ID starts with “5”) AND IP Description is “Movie Screenplay”
The syntax for a typical search is as follows: <Attribute><Operator><Value>
, where <Operator>
is the relationship between <Attribute>
and <Value>
, which
needs to be met for a match to be found. An operator can be:
Is
, where the specified attribute has to equal the specified value or date (for example IP ID is
0100).
Is not
, where the specified attribute has to be not equal the specified value (for example IP ID is not
0100).
Contains
, where the specified attribute contains the specified value (for example, IP Description contains
“Book”).
Starts with
, where the specified attribute begins with the specified value (for example, IP Description starts with
“Book”).
Is between
, where the specified attribute has a value or date between two specified values (for example, Publication Date is between
March 1 and May 30).
Is less than
, where the specified attribute has a value less than the specified value (for example, IP ID is less than
0500).
Is greater than
, where the specified attribute has a value greater than the specified value (for example, IP ID is greater than
0100).
Is earlier than
, where the specified attribute has a date earlier than the specified value (for example, Publication Date is earlier than
March 15).
Is later than
, where the specified attribute has a date later than the specified value (for example, Publication Date is later than
March 30).
Notes on Specific Search Operators When Searching for Rights Groups
When you search for rights groups (for example, Rights Owned — Rights Groups, or Release Dates — Rights Groups), the software interprets the Is
and Contains
operators as follows:
Is
operator
The system searches for a direct match, and only direct match. For example, if the search criteria is: “Market is
Books”, but the rights contained in the rights group are “Books; TV”, then
this search will not result in a hit. In addition, if the rights contained in the rights group are “All”, this will not
result in a hit.
Contains
operator
The system finds a match if the searched rights are contained within the rights group. This operator considers the hierarchical nature of rights dimensions. Thus if the search criteria is “Market contains
Books”,
this will result in a hit if the rights are “Books; TV”, and will also result in a hit if the rights are “All”.
The Maximum Number of Results
field allows you to specify the maximum number of search results that are returned. This prevents the system timeouts in the event that your search criteria results in a large number of results.
You can press Clear
to clear the selection fields of any entered values.