Beyond Category has several list features to allow quick retrieval of queries regarding data stored on the database. Many of the lists are contextual, meaning that they only work in the context of what is displayed in a window. The list to display all albums is non-contextual – it can be displayed at any time regardless of which windows is active. The list of albums containing a specific song is contextual in that it can only be used to display information of the current song selected in the Songs window.
Lists generated from Beyond Category
- List All Albums – a complete list of albums entered in the database.
- List All Songs – a complete list of songs entered in the database.
- List Albums for Song – a list of albums containing the song displayed.
- List Songs Used On Albums – a list of songs that have been assigned to at least one album.
- List All Personnel – a complete list of personnel entered in the database.
- List Albums for Person – a list of albums where the person displayed appears.
- List Albums Filed Under Person – a list of albums where the displayed person is the album file artist.
- List Tracks for Person – a list of album tracks the person displayed appears on.
- List Personnel Used on Album – a list of personnel that are assigned to at least one album.
- List All Composers – a complete list of composers entered in the database.
- List Songs by Composer – a list of songs entered in the database where the displayed composer is credited.
- List Tracks by Composer – a list of songs entered in the database where the displayed composer is credited.
- List All Labels – a complete list of labels entered in the database.
- List Albums for Label – a list of albums for the label displayed.
- List Playlists – a complete list of the playlists entered in the database.
Common List Features
The lists share common features of searching, exporting, sorting, and customization.
At the bottom of the list window is a text field for entering a string of characters used in searching the list.
Entering a string of characters activates the Find button. After using the Find button to initiate a search, the Next button will
activate for the purpose of finding subsequent entries. Hotkeys can be used for these features. (Command-f and Command-g for the Mac
or Control-f and Control-g for Windows.)
The search begins at the entry selected in the list. When first
opening a list window, the search position is the top of the list. After starting a search,
the Start At Beginning checkbox must be clicked to force a subsequent search to begin at the top of the list.
The searches will not “wrap”. At the end of the found entries for a search, any subsequent search will fail.
The Up and Down radio buttons allow for change of direction on the search.
Any list can be exported to a tab-delimited text file suitable for opening in Microsoft Excel. Use the Export button at the bottom
of the list window.
Sort order of lists can be changed by clicking on the heading of any column. Clicking will rotate the sort from ascending to descending order.
Columns in lists can be resized by dragging. The preferences file will remember the customization of the columns and the position
of the window on the screen when the list window is closed.
Double clicking on an entry in the list will navigate to an appropriate display of the entry. What does “appropriate” mean? If you are looking
at a list of all songs in the database and click on an entry, it will bring you to the Songs window and display the entry for the song.
If you are looking at a list of all albums or a list of all tracks, double clicking will bring you to the entry for that album in the Albums window.
Use the File->Print menu to print the lists. The colum widths of the printout will correspond to the percentage of widths displayed on the list.
Adjust the widths on the window by dragging the edge of the column header.
List Descriptions
List All Albums
A complete list of albums entered in the database. Included columns are Label, Catalog Number, Format, Artist, Album Title,
Record Added, Record Modified.
Note, the artist column in this list denotes the artist entered as the File Artist for the album, not any artist entered as
a performer on the album.
A handy feature of this list is to easily find the most recent albums entered or modified by sorting the list by the Record Added
or Record Modified columns.
List All Songs
A complete list of songs entered in the database. This list will include songs entered via the Songs window, but not used on
any album.
List Albums for Song
A list of albums containing the song currently displayed in the Songs window.
List Songs Used On Albums
A list of songs that have been assigned to at least one album.
List All Personnel
A complete list of personnel entered in the database.
List Albums for Person
A list of albums where the person displayed in the Personnel window appears as a performer. This means that if an artist is entered
as the file artist of the album, but not listed as a performer for one of the tracks, that album will NOT appear in the list.
List Albums Filed Under Person
A list of albums where the displayed person is the album file artist.
List Tracks for Person
A list of album tracks the person displayed in the Personnel window appears as a performer. This list will list the specific
tracks on any album the artist appears on.
List Personnel Used on Album
A list of personnel that are assigned to at least one album.
List All Composers
A complete list of composers entered in the database.
List Songs by Composer
A list of songs entered in the database where the displayed composer is credited.
List Tracks by Composer
A list of tracks entered in the database where the displayed composer is credited.
List All Labels
A complete list of labels entered in the database.
List Albums for Label
A list of albums for the label displayed in the Albums window.
List Playlists
A complete list of the playlists entered in the database.