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:
- View more details by clicking on the links in the table. Users with editor or administrator permissions can also edit the items.
- Download reports so you can use the data in other applications. Clicking "Download all results as a CSV file" downloads all results matching your search criteria, not just the ones displayed on the current page.
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).
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).
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.
It produces a single-column table of labels matching your search substring and uses only the Label name criterion
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.
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.
- Artist — artist name
- Disk — disk name
- Song — song name, only applicable to Song spin statistics reports
- Format — media format, e.g. CD, LP, 7-Inch, etc.
- Type — type of release, e.g. album, single, ep, comp, etc.
- Library — in which library at the station the disks are filed – usually corresponds to genre
- Year — the disks year of release
- Local — is the disk's Local flag set?
- Label — record label name
- Add date — when searching for disks or spin stats you can check Add date set to find only disks that have the add date field set and then choose a range of dates to include in the results
- New — is the disk's New flag set?
- Played — when searching for disk or song spin stats you can constrain the range of dates when the disk was played