User Guide

27
Now enter the Filter to be used for creating the results desired. This is where it can be
complicated or simple. This example is simple, use the keyword ‘top’ with the number ‘100’
and the element ‘nbplay’. ‘nbplay’ looks at the Play Count data field. As the filter statement is
entered VirtualDJ evaluates that the statement is properly created. The OK button will remain
‘grayed’ out if the statement is not well-formed.
So the entire filter statement would look like ‘top 100 nbplay’. What VirtualDJ will do each
time this folder is selected with sort the entire database on the Play Count field in Descending
order and then display the first 100 entries or the Top 100.
The filter dialog provides some great examples but to get it’s real power need to now what are
the appropriate elements, operators, and a few keywords that are used.
Elements - "title", "author", "artist", "album", "genre", "year", "bpm", "key", "bitrate", "songlen",
"filesize", "filepath", "filename", "extension", "hascover", "isscanned", "alreadyplayed",
"lastplay", "firstplay", "firstseen", "nbplay", "type", "days since firstseen", "days since firstplay",
"days since lastplay", "LinkedVideo", "HasLinkedVideo"
Operators – "==", "=", ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains",
"contain", "doesn’t contain", "starts with", "start with", "ends with", "end with ", "and ",
"or ", "&&", "||", "&", "|"
Keywords – “top”, “[inverted]”
Filter Folder Examples
FILTER Expected Result
isscanned=0 or isscanned=1 Local Database
top 100 nbplay top 100 list
top 100 firstseen recently added
top 100 lastplay recently played
bpm>120 and bpm<130 bpm range from 120 to 130
Year>=1980 and year<1990 80s music
Days since lastplay<7 songs played last week
Days since lastplay<31 songs played last month
Days since lastplay<365 songs played last year
lastplay=0 never played songs
isscanned=0 files not scanned
type=video video group
type=audio audio group
type=karaoke karaoke group
hascover=1 has cover picture
hascover=0 doesn't have cover picture
top 20 nbplay and hascover=1 and
(type=video or type=karaoke)
Top 20 most played that have a cover and
are Video or Karaoke files
filepath start with "c:\mp3\80s" or filepath
start with "d:\music\80s"
Show all 80s files stored on two separate
drives in a folder titled 80s
extension is "mp3" and title doesn't contain
"madona"
Any mp3 file that does not contain
“madona” in the title