Foobar2000:Components 0.9/Randomized Playlist Entry (foo random)/Query syntax

From Hydrogenaudio Knowledgebase
Revision as of 12:28, 29 June 2008 by Zarkon (talk | contribs) (Foobar2000:Query syntax moved to Foobar2000:Components 0.9/Randomized Playlist Entry (foo random)/Query syntax: In preparation for query syntax page which applies to the query syntax supported by the Media Library Search component)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Foobar2000_Logo.png

Query syntax used for Foobar2000:Components_0.9/Randomized_Playlist_Entry_(foo_random)

Simple search:

  • "<any string>" - returns only items that have all words from specified string in their metadata / tech infos / file path.

Advanced search:

  • "<field> HAS <string>" - returns only items that have all words from <string> in metadata field named <field>, e.g. "title HAS blah".
  • "<field> IS <string>" - returns only items where (at least one) metadata field <field> is equal to <string>, e.g. "artist IS blah".
  • "* HAS <string>" - same as simple search, but can be combined using logical operators (see below).
  • "<pattern1> AND <pattern2>" - performs logical AND operation on two search patterns, e.g. "artist IS blah AND title HAS blah". You can also enclose patterns in parentheses to control order of logical operations, e.g. "(artist IS blah) AND (title HAS blah)".
  • "<pattern1> OR <pattern2>" - same as above, but with OR logical operation.
  • "NOT <pattern>" - inverts results of <pattern>, e.g. "NOT comment HAS sucks".
  • "<field> GREATER <number>", "<field> LESS <number>", "<field> EQUAL <number>" - performs integral number comparison between <field> value and <number>, e.g. "date LESS 1998".
  • "<field> MISSING" - returns only items where <field> is not defined, <field> must be a field name without percent signs

Note 1 : <field> and <string> in HAS/IS operations should be enclosed in double quotation marks (") if it includes spaces. Note 2 : If <field> in HAS/IS/GREATER/LESS/EQUAL includes at least one of #$% characters, it will be treated as title formatting string, e.g. " "%__codec%" IS MP3". Using title formatting string instead of simple field name will decrease search speed and break multiple field handling in IS operator. Note 3 : All search operations are non-case sensitive. All operator words *must* be uppercase.