Filter Folder Examples

Filter Folder Examples
The elements, operators, and a few keywords that are used.

Elements	"title", "author", "artist", "album", "genre", "year", "bpm", "key", "bitrate", "songlen", "filesize", "filepath", "filename", "rating", "composer", "field1", field2", "extension", "hascover", "isscanned", "alreadyplayed", "lastplay", "firstplay", "firstseen", "nbplay", "type", "days since firstseen", "days since firstplay","days since lastplay", "LinkedVideo", "HasLinkedVideo", “bpmdiff”, “keydiff”, “ispresent”, “inSearchDB”
Operators	"==", "=", ">=", "<=", "!=", "<>", ">", "<", "is not", "is", "equals”, "equal", "contains", "contain", "doesnt contain", "don't contain", "starts with", "start with", "ends with", "end with ", "and ", "or ", "&&", "||", "&", "|"
Keywords	“top”, “[inverted]”

From the Manual -

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

Complex Filters
Filter: top 20 nbplay and hascover=1 and (type=video or type=karaoke)
Result: Top 20 most played that have a cover and are Video or Karaoke files

Filter: filepath start with "c:\mp3\80s" or filepath start with "d:\music\80s"
Result: Show all 80s files stored on two separate drives in a folder titled 80s

Filter: extension is "mp3" and title doesn't contain "madona"
Result: Any mp3 file that does not contain “madona” in the title

1. Local Database
   
   Prior versions of VirtualDJ contained a Local Database node in the Navigation panel.
   Here is how you can recreate the Local Database using a Filter folder -
   
   Name: Local Database - Analyzed
   Filter: isscanned=1
   
   Name: Local Database - Not Analyzed
   Filter: isscanned=0
   
   Name: Local Database - ALL
   Filter: isscanned=1 or isscanned=0
   
2. Top number of Tracks Played
   
   Name: Top 100 Videos
   Filter: type=video and top 100 nbplay
   
   Name: Top 100 Played
   Filter: top 100 nbplay
   
   Name: Top 20 Latin
   Filter: Top 20 nbplay and genre=latin
   
3. Smart Folders
   
   Name: Recently added
   Filter: top 100 firstseen
   
   Name: Recently played
   Filter: days since lastplay<1
   
   Name: All Funkymix/Ultimix/Umix
   Filter: title contains "funkymix" OR title contains "ultimix" OR title contains "u-mix"
   
   Name: UK No1
   Filter: comment contains "(UK No 1)"
   
   Name: My Mixes
   Filter: comment contains "Mymix"
   
   Name: mp3's
   Filter: filename contains ".mp3"
   
   Name: 70's and 80's
   Filter: year>=1970 and year<1990
   
   Name: AAMMDDHHMM = Année, Mois, Date, Heure, Minute
   Filter: firstseen> 1003010000 and firstseen <1007312359
   
   Name: mainstream radio
   Filter: comment contains "mainstream" or comment contains "promo"
   
   Name: specific genre
   Filter: genre contains "specific genre"
   
   Name : Songs without genre
   Filter : genre is ""
   
4. BPM Organized
   
   This will organize all files from 90 bpm to 95 bpm:
   Name: BPM 90 - 95
   Filter: bpm>=90 and bpm <=94
   
   This will organize all files from 95 bpm to 100 bpm:
   Name: BPM 95 - 100
   Filter: bpm>=95 and bpm <=99
   
5. Rated Files
   
   This will give you the top rated files (5&4 stars)
   Name: Top Rated
   Filter: rating>3
   
   This will return the files that are not rated yet
   Name: Unrated
   Filter: rating=0