| Database queries
|
|
|
| You might not always want to use the whole music library to produce a playlist from, but rather search for specific titles and then run these titles through the playlist algorithm.
|
|
|
| There are several ways to extract certain titles from the database:
|
|
|
|
|
| 1) Select individual titles separately from the whole database ( see chapter title collection) :
|
|
|
| 2) Quick search : Search for one certain criterium
|
|
|
|
|
|
|
|
|
| 3) combined search : search for the combination of criteria with an AND or OR link
|
|
|
|
|
|
| 4) search for personalised preferences and 4 other criteria
|
|
|
|
|
|
|
|
| 5) Search all date fields for changed data records or soundfiles or for dates when a song has last been played. or search in numeric fields for titles with a specific file size, running length or BPM (beats per minute).
|
|
|
|
|
|
| 5) Search for duplicate titles : Moodmixer sets up a list with all duplicate titles, they can either be deleted or profiled with the preference value 0 ( won't be played).
|
|
|
|
|
|
| 6) Search for titles without soundfile: if for example one has moved the soundfiles to another folder or drive Moodmixer can't find them anymore- no need to scan them again - simply use the [search and replace]-function for the path and set the new directory.
|
|
|
|
|
|
|
|
|
|
| 7) | For those of you who want to try a SQL-sequence ( at your own risk- program might crash!) : you can enter an SQL-string as a search for titles:
|
|
|
|
|
|
|
|
|
|
| No matter what kind of search is conducted- the result is always a want list. These want lists are dynamic - as soon as you open a saved want list- the actual search is conducted again- so if you have new titles in your database or the profiling has changed - the want list might change too.
|
|
|
| How to exactly conduct any of those searches is described in detail in the following chapters:
|
|
|
| Quick search
|
| combined search
|
| search in date or numeric fields
|
| search for duplicates
|
| SQL-search
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|