User Guide

23
N 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’
ement is not well-formed.
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
xamples but to get it’s real power need to now what are
e appropriate elements, operators, and a few keywords that are used.
, "key", "bitrate", "songlen",
lesize", "filepath", "filename", "extension", "hascover", "isscanned", "alreadyplayed",
tseen", "days since firstplay",
ays since lastplay"
, ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains",
Filter Folder Examples
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’
ement is not well-formed.
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
xamples but to get it’s real power need to now what are
e appropriate elements, operators, and a few keywords that are used.
, "key", "bitrate", "songlen",
lesize", "filepath", "filename", "extension", "hascover", "isscanned", "alreadyplayed",
tseen", "days since firstplay",
ays since lastplay"
, ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains",
Filter Folder Examples
ow enter the Filter tonter the Filter to
cc
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 stat
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 stat
So th So th
titi
order and then display the first 100 entries or the Top 100.
The filter dialog provides some great e
order and then display the first 100 entries or the Top 100.
The filter dialog provides some great e
thth
Elements - "title", "author", "artist", "album", "genre", "year", "bpm" Elements - "title", "author", "artist", "album", "genre", "year", "bpm"
"fi
"lastplay", "firstplay", "firstseen", "nbplay", "type", "days since firs
"fi
"lastplay", "firstplay", "firstseen", "nbplay", "type", "days since firs
"d"d
O
"c
O
"c
perators – "==", "="perators – "==", "="
ontain", "doesnt contain", "doesn’t contain", "don't contain", "starts with", "start with", "ends
with", "end with ", "and ",
"or ", "&&", "||", "&", "|"
ontain", "doesnt contain", "doesn’t contain", "don't contain", "starts with", "start with", "ends
with", "end with ", "and ",
"or ", "&&", "||", "&", "|"
KKeywords – “top”, “[inverted]” eywords – “top”, “[inverted]”
FILTER Expected Result
isscanned=0 or isscanned= Local Database1
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