Schubert Filmography

Instructions
On the filmography page, you may select the detail that you wish to view. Your instructions are executed each time you press the 'Update Options' button, and details of your selections are remembered, so you can revise some of your selections, and try again. The URL that gets generated from your selections, which can be seen in the address bar of your browser, can be saved as a favourite, or used in links from your website. The links to the 'type' filmographies in the menu bars on this website work in this manner.

Once onto the filmography page, you can change the details that you wish to view by changing the controls at the top of the page. These are of three types, which are described below:

Display Options

There are check boxes to enable or disable parts of the display. Each option will apply when the 'Update Options' button is pressed if the check box is checked. The display Options are:
  • Show DB Stats. This option displays statistics about the filmography database including version information, the last date it was updated, and the number of entries for each type of film.

Filters

There are 3 list boxes and 2 text boxes to filter the films that are returned by the query. There are list box filters for Film Type, Country and Works. Each Filter has an 'All' option, which means that no filering applies for that column. The other options in the filter list boxes are all the values for that column in the database. If one is selected, then ONLY films that match that filter will be shown in the results.

You may use as many of the filters as you want, though each filter that you use is likely to reduce the number of films you see in the results, since films must match ALL the filters to be included. It is easy to select a combination of filters that will return no results.

Films may have multile source countries specified, and the country filter will select any film that contains the name of the selected country, not just those made exclusively in that country.

The Works filter contains a list of all the works noted in the films. Works are listed in D number order (D numbers are named after the musicologist Otto Erich Deutsch who published a list of Schubert works in (approximately) chronological order). Deutsch numbers that apply to works with multiple parts (e.g. movements of works, collections of songs or dances, etc) may have a specific part quoted with a further number (after a '/') following the D number. Some films quote specific parts of works, others just the work in general. Thus, for example, some films quote D759 (the "Unfinished" Symphony), whilst others quote a specific movement, such as D759/1 for the 1st movement. If you filter on the movement then you will only see the films that quote the movement; if you filter on the work as a whole, you will get the films that quote the work as a whole, AND the films that quote specific movement(s) of the work.

You may also filter the list of films by specifying a date range. Enter the earliest year that you wish to see films for in the 'From Year' edit box, and/or the latest year that you wish to see films for in the 'To Year' edit box. If you specify just one of the ranges, then the other does not apply. So, for example, if you just enter 1940 in the 'From Year' edit box, you will see films from 1940 onwards, with no upper limit.

Sort sequences

There are 3 list boxes with associated radio buttons to select the sort sequence for the records that are returned in the results table. The sort selections are applied in priority order (top to bottom), and each can be sorted in either ascending or descending order.

There is, of course, no point in sorting on a column that you have filtered (since all the records shown will have the same value). Similarly, there is no point on sorting on the same column twice! However, neither of these options will 'break' the sorting, so there is no need to change the sort options every time you change the filters.

The films in the results are actually sorted on an underlying key value, which may not be exactly what is shown in the filter list boxes and the results. For the film type, the sort sequence is on a one character abbreviation of the type. For the film title, the sort is on an internal 'Short Name' which is not visible to you. This produces a sort sequence that is close to alphabetic order, after the removal of leading definite and indefinite articles ('the' or 'a', etc., in the language of the film title). For country, the sort is on the text field, which may include several countries. So films produced in several countries will effectively be sorted on the first such country listed.