Schubert Deltiography

Instructions
On the Deltiography 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 Deltiographies of catalogue sections in the menu bars on this website work in this manner.

Once onto the Deltiography 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: Each postcard in the results table has a 'details' link (a thumbnail picture if we have one, otherwise a text link) that will take you to a page with full details of that postcard. In addition to the information in the results table, the postcard details page has various notes (which may be switched off in the results table), and a listing of all known variants of the postcard, with publisher, title, etc., information, further notes, and, if we have them, pictures of the face and rear of the card. Where a card has multiple variants, the pictures shown are for a selected variant. There is a link to click for each variant to display pictures of that particular variant.

Display Options

There are 4 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 database in general (some information is shared across the ographies including version information, and the last date it was updated). It also displays information specifc to the postcardography, including numbers of cards and variants and numbers in each section..
  • Abbreviate. This option abbreviates the catalogue section to just 1, 2 or 3 characters, and abbreviates the publisher, artist and work from full names to the internal keys used in the database, which are usually sufficiently informative for this option to be usable. The date is abbreviated to just a year, without any explanation.
  • Show Notes. This option displays notes. General notes about the card appear in a comments column in the result table. Notes about the date appear in the date column.
  • Show Just Thumbnails. This option displays just the thumbnail pictures of postcards, complete with links to the postcard details page. Useful for quickly viewing many cards before drilling ito the detail.
  • Show All variants. This option displays all the variants of postcards in the results table, instead of just a single entry for a postcard. This is useful when variants may have different numbers or publishers.

Filters

There are 4 list boxes to filter the records that are returned in the results table. There are filters for Catalogue Section, Publisher, Artist and Schubert Work. Each Filter has an 'All' option, which means that no filtering 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 records that match that filter will be shown in the result table. The Works filter contains a list of all the works noted in postcards and films (the works table is shared between them, so there may be some works quoted that only appear in films, not on postcards). 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 postcards quote specific parts of works, others just the work in general. Thus, for example, some 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 postcards that quote the movement; if you filter on the work as a whole, you will get the postcards that quote the work as a whole, AND the postcards that quote specific movement(s) of the work.

You may also filter the list of postcards by specifying a date range. Enter the earliest year that you wish to see postcards for in the 'From Year' edit box, and/or the latest year that you wish to see postcards 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. Similarly, you may also filter the list of postcards by specifying a (publisher's) card number range. Enter the lowest number that you wish to see postcards for in the 'From Ref' edit box, and/or the highest number that you wish to see postcards for in the 'To Ref' edit box. If you specify just one of the ranges, then the other does not apply. So, for example, if you just enter 1000 in the 'From Ref' edit box, you will see postcards numbered 1000 and higher, with no upper limit.

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

Columns which are filtered to a single value are not shown in the results table (there would be no point, as every row would have the same value).

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 records in the results table are actually sorted on an underlying key value, which may not be exactly what is shown in the filter list boxes and the results table. For those columns that can be abbreviated (publisher, artist and work) the sort values are the abbreviations (which are the database keys). In general, those postcards without a valid value for a field being sorted (e.g. where there is no publisher information or artist on the card) are sorted to the end of the sort sequence.