To see the actual value stored, use an expression column with the raw format field specifier ,0 in the field name just before the closing bracket.

For example, if the field is set with the value of 0, it will show in a pane column or cell as empty. Note: For numeric types, the value of 0 is stored as a 0 internally, but Media Center uses a formatted display version of the field and shows it as an empty value. For string types, the 0 and empty values are distinct. When comparing against numeric values, both 0 and empty are considered equivalent and either may be used. A 0 value for numeric types will be displayed in Media Center as empty, whereas for string types, as a 0.

When comparing the values of 0 and empty, it is important to understand how Media Center both stores and displays these values for the numeric and string datatypes. Floating point values may be used (e.g.5w for 1/2 week). These allow defining a search term to compare a specified value against a given field (also called property).įor fields of type Date, values may include units such as d, w, y, h, m and s to indicate day, week, month, year, hour, minute, and second respectively. The query language provides the standard comparison operators of equal-to, less-than, less-than/equal-to, greater-than and greater-than/equal-to. Following that will be a description of search query Modifiers. The next few sections describe the available operators available to construct search queries from simple to complex. Sorting is done by the view, or specifically by other query constructs such as Modifiers. Keep in mind that the order of the files returned from a query is generally undefined or random. Generally, any library field may be used in a query see the Media Center File Properties document for a list of the standard properties, and see Options > Library & Folders > Manage Library Fields for the complete list, including custom user fields. Queries all files whose Name contains Midnight and from those, queries the current list to test that the Artist property contains Thelonious. Multiple search terms are combined by an implicit and operator. Files that match are included in the resulting list non-matching files are excluded.Ĭompound queries may be constructed by adding additional search terms, thus testing additional properties. Queries all files asking if the Album property contains the exact sequence of (case-insensitive) letters pina. For example, the following search phrase: Queries can be entered in the Search bar using Text or Wizard mode, the Edit Smartlist dialog box, and in any Set rules for file display dialog available in view customization (Standard View, Theater View, Gizmo/WebGizmo, Media Network's DLNA server).Ī simple query might test some value against the contents of a specific property, such as the name of an album, a date, or episode number. Queries are used or input in numerous places throughout Media Center - they are the heart of what drives file list production used to populate Views (panes and categories values, file lists) and Smartlists, or via Search to narrow the list of files presented in the current view. So long as the query produces a true value (a value of 1), the file will be included. Queries can generally test any file properties, or even test the results from an evaluated expression. From the list of all imported files, a initial search term reduces the list, and additional search terms further narrows the results to produce a final list of matching files.

Each search term, in order, is tested against every file in the current file list. If the search phrase evaluates to true for the file, the file is included in the final file list otherwise, it is not.Ī search phrase may be one or more search terms. audio tracks, image files, video files, etc.) that has been imported.Ĭonceptually, when performing a query, Media Center tests a search phrase against each file in the library. Being at its core a database, the Media Center library maintains information (or properties) for each file (e.g. Before getting too detailed, it is essential to have a basic understanding of how a query works in Media Center.

Jriver media center 22 search