Page 23 - s

be used for creating the results desired. This is where it can be
nter
Now enter the Filter to the Filter to be used for creating the results desired. This is where it can be
omplicated or simple. This example is simple, use the keyword ‘top’ with the number ‘100’
c c omplicated 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
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
entered VirtualDJ evaluates that the statement is properly created. The OK button will remain
ement is not well-formed.
‘grayed’ out if the stat
‘grayed’ out if the stat ement is not well-formed.

e entire filter statement would look like ‘top 100 nbplay’. What VirtualDJ will do each
So th
So th e entire filter statement would look like ‘top 100 nbplay’. What VirtualDJ will do each
me this folder is selected with sort the entire database on the Play Count field in Descending
titi me this folder is selected with sort the entire database on the Play Count field in Descending
the first
100 entries or the Top 100.
order and then display
order and then display the first 100 entries or the Top 100.

xamples but to get it’s real power need to now what are
The filter dialog provides some great e
The filter dialog provides some great e xamples but to get it’s real power need to now what are
e appropriate elements, operators, and a few keywords that are used.
thth e appropriate elements, operators, and a few keywords that are used.

Elements - "title", "author", "artist", "a lbum", "genre", "year", "bpm" , "key", "bitrate", "songlen",
Elements - "title", "author", "artist", "album", "genre", "year", "bpm"
, "key", "bitrate", "songlen",
lesize", "filepath", "filename", "extension", "hascover", "isscanned", "alreadyplayed",
"fi "fi lesize", "filepath", "filename", "extension", "hascover", "isscanned", "alreadyplayed",
"lastplay", "firstplay", "firstseen", "nbplay", "type", "days since firs
tseen", "days since firstplay",
"lastplay", "firstplay", "firsts een", "nbplay", "type", "days since firs tseen", "days since firstplay",
ays since lastplay"
"d "d ays since lastplay"

, ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains",
"==", "="
O Operators – "==", "=" , ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains",
–
perators
"c "contain", "doesnt contain", "doesn’t contain", "don't contain", "starts with", "start with", "ends
ontain", "doesnt contain", "doesn’t contain", "don't contain", "starts with", "start with", "ends
with", "end with ", "and ",
with", "end with ", "and ",
"or ", "&&", "||", "&", "|"
"or ", "&&", "||", "&", "|"

– “top”, “[inverted]”
K Keywords – “top”, “[inverted]”
w
ords
ey
Filter Folder Examples
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 Top 20 most played that have a cover and
(type=video or type=karaoke) are Video or Karaoke files
filepath start with "c:\mp3\80s" or filepath Show all 80s files stored on two separate
start with "d:\music\80s" drives in a folder titled 80s
extension is "mp3" and title doesn't contain Any mp3 file that does not contain
"madona" “madona” in the title
23