Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

For example, the filters:

Image Added

results in the if-statement (pseudo code):

Code Block
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()
}



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

Image RemovedImage Added

In the window, which pops up, there are three tabs:  Meta data Metadata field,   Table and column, and Draft - Predefined. If a filter is predefined, every aspect of the filter is hardcoded, ie the user has no way to change the filter during creation. As such, the predefined filter will not be mentioned below.A filter MUST and Predefined. (For an image please see "3 Comparison Type")

A Metadata field or 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 Table and column or a Metadata field.
  • The Comparison Type, which decides what logic the filter will apply to the data being worked with.
  • The Input Type, which determines how the Media Manager and Video Portal gather input for a search (some Comparison Types does not have an 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 MAY have Predetermined values, which MUST be supplied before the filter can be created.