2 Filter

A filter can be compared to a single condition in an if-statement. Usually (almost always, see 7 Group) the operators in the if-statement are "&&" (in JavaScript/C#)/"AND" (SQL).

For example, the filters:

results in the if-statement (pseudo code):

If(asset.asset_type is in the supplied list of asset types 
	AND asset.assetid is in the supplied list of asset IDs
	AND asset.itemid is in the supplied list of item IDs) {
         AddAssetToResults()
}

A filter can be created by selecting the Input tab in the Search Editor and then clicking the "Add" button (see 1 Create a Keywords filter for a detailed explanation on how to create a filter):

In the window which pops up, there are three tabs: 12 Meta data field, 14 Table and column, and 13 Predefined.

A 12 Meta data field or 14 Table and column filter MUST have some properties defined before it can be added to a search:

• The data, which the filter does work with. This is either a combination of 14 Table and column or a 12 Meta data field.
• The 3 Comparison Type, which decides what logic the filter will apply to the data being worked with.
• The 4 Input Type, which determines how the Media Manager and Video Portal gather input for a search (some 3 Comparison Types does not have an 4 Input Type associated with it; in these cases an input type is not required).
•  The  ID.

If a predefined filter is needed, then the input from the user is usually only an ID. Though some predefined filters have 5 Predetermined values, which MUST be supplied before the filter can be created.