Searching the music database

You can search the music database and generate charts and reports that can be downloaded if desired. Editor and administrator users can also clean up duplicate items in the music database with the search page. The search results will be displayed in a table, where you can:

Search and report types

Each search type produces a different kind of results table with its own set of columns. Click Search music database in the main menu. Select the desired item from the Search drop-down menu and set your search criteria to narrow your search (not all search criteria are applicable to all report types).

Artists

It produces a single-column table of artists and uses only the Artist name criterion. This search is useful to check for duplicate entries of artists in your database to combine or edit them (you need editor or administrator permission to combine items).

Disks

It generates a table of disks containing columns with all the available artist, disk and label data. All the artist disk and label criteria are available to constrain this search type. All disks by all artists matching your criteria will be displayed.

Labels

It produces a single-column table of labels matching your search substring and uses only the Label name criterion

Songs

It generates a table of songs with artist, disk and label data. You can search for songs in playlists by specifying a date range or for songs that aren't in any playlist, i.e. imported songs or songs from deleted playlists (if your station has few of these then this option isn't displayed). Searching for played songs provides details on who played the song and when with a link to the playlist. All the criteria are available to constrain this search type.

Disk & song spin statistics

It creates a list of disks or songs spun during a specified range of dates ordered by number of spins. Set the range of dates and any other criteria you like. The resulting chart will display the disks or songs with the most frequently played first.

Search criteria

All text fields are prefix search keys. Thus you can find Dusty Springfield by typing the search keys "dust" or "sprin" into Artist but not with "usty" or "ring".

Several criteria can be used in producing different search reports. Not all criteria are applicable to some report types.

Any or all criteria can be left unset if you don't want to constrain the search with that field.

Text fields are not case sensitive.