Search and Sort options

WineBase features extensive Search and Sorting options and these are presented in one dialog box. From this dialog you can search for and sort the wines in your cellar. Some of these search options are also available via the menus or by other buttons on the WineBar.

On the Main WineBar...

...click this button or you can use the View - Search and Sort Options... menus.

Find Wines Matching
All Wines - Same as
'Lost Souls' - All Wines with a total stock of Zero.
Non Vintage, Young, Improving, Mature and Danger - Same as
Other Search Options

With the possible exception of Drinking Ratio I don't think any of these require any more explaining than what's written in the dialog or it's title.

Text Search... - Same as
Search all fields...
Blend Component...
Drinking Ratio...

The number of bottles of a wine that are available to drink each year, within the range of 1/4 (one every 4 years) to 52 (one a week), from This Year to the GoodTo date.

Given that Total Years is equal to GoodTo - Vintage + 1.

Mature Only only covers the middle 1/3 of Total years.

Mature Onwards only covers the last 2/3 of Total Years.

All Years covers all of Total Years.

Future one Year...
Future all Years... - Same as
Find all wines at their Best by year for the next 25 years.

or Search in one of these fields

A field or more correctly a data field is a single item such as Vintage in a database like WineBase. It's often useful to be able to search a single field for just one selection, like a single winery. WineBase allows you to search nine of the more useful data fields.

To select a field just click the button for that field and all the entries in your cellar for that field will be listed. Click on the required entry from the list.

Click the button to start the search.

Region and Location fields ONLY (Display Lost Souls as well)

Usually WineBase only searches for wines that have stock. Which makes sense as why search for a wine that isn't there. However when you drink the last bottle of a wine by using the Quick Drink function or via the Main Edit dialog WineBase doesn't delete the wine.

It stays in the database as a Lost Soul which is a wine without stock. A wine you used to have, a wine you may be getting more of or a wine that has useful information such as ratings and tasting notes that you may want to refer to in future. These wines will not show up in Listings from searches like the one above or any other search for that matter apart from a search for just them.

There is however a really useful thing that they can be used for the two of the fields, Region and Location.

Region

Whilst you can put anything in the Region field it's useful to adopt a format like this which is the default format that WineBase uses.

South Australia Barossa becomes SA Barossa Valley
Victoria Yarra Valley becomes VIC Yarra Valley

If you wish to extend this further to include countries you could adopt a format like ...

Australia, Victoria, Yarra Valley AUS VIC Yarra Valley
Australia, South Australia, Barossa Valley AUS SA Barossa Valley
France, Bordeaux, The Medoc FRA BOR The Medoc
France, Burgundy, Chablis FRA BUR Chablis

You then create some Lost Soul wildcard files to use as Search Keys.

I enter a Winery name of Wildcard, so I know the wine is a Search Key and that I shouldn't delete it. You will need to enter one 'WildCard' for each Region you wish to search for and save the file with a stock level of 0 Bottles and 0 Cases and a region of ...

AUS
AUS VIC
AUS VIC Yarra Valley
AUS SA
AUS SA Barossa
AUS SA Clare Valley
FRA
FRA BOR

There has to be a SPACE between each word.

As searching for AUS will find all wines that have a region starting with AUS, you can list all wines from Australia and still be able to find regional wines by searching on for example AUS VIC Yarra Valley.

Same goes for Location

The Cellar Location can also be used in this way. With a warning about keeping the length of the Cellar Location short so you can display it all, in mind. A point of interest.

The way the alphabetical searching works in WineBase is for each word to be treated as a separate search criteria. This means that A BC, A ZZ and AAA would all be found by searching for A.

So if you use different racks or locations and a 'SpreadSheet' format (A1..Z100 etc) index system you could enter the Cellar Locations as a character string such as R9999 AA99.

Where R9999 is the rack or location such as Rack1, Rack2, DBin1 (Diamond Bin 1) etc. followed by a SPACE and AA99 is the cross reference to where the bottle (or case) is. Probably not needed for a Diamond Bin as all the wines in one are usually the same.

As each location will be unique, you only need to create a common search key for all wines that use the same rack or location.

So create some Lost Souls with Rack1, Rack2, etc as the Location and you can then just list all the wines in that one rack or location.

Sort by

You can sort the Index listing by any of listed fields. Select the required sort order by clicking on the corresponding 'Radio Button'. This is the primary Sort Field, but the sorting continues in all the major fields, with the 2nd, 3rd etc sort keys being determined on the primary key.

ie. Sorting on Vintage, would then sort on Winery, Label and Variety.

The '4 Keys' option lets you set the order of the first 4 sort keys. This gives you finer control on how you want the data sorted.

Reverse Sort does what it suggests.

Best to Drink Now Lists all the wines that are currently at their best. Both this Search and the 'At a Future Date' Search using the BestAt date of the wine as a search criteria.

Find Text Lists all wines that have a text string in the Comments or Tasting Schedule files that match the search string.

Search all Fields Will search every field of your main database for any text, partial or complete, beginning with or containing that text. This is very powerful search option.

Component of Blend Finds all wines that include the named variety. This can be used for example to find all wines that have Merlot in them. Enter the required variety or part thereof and not case sensitive and click OK.

Sort by You can sort the Index listing by any of eight fields. Select the required sort order by clicking on the corresponding 'Radio Button'. This is the primary Sort Field, but the sorting continues in all the major fields, with the 2nd, 3rd etc sort keys being determined on the primary key. ie. Sorting on Vintage, would then sort on Winery, Label and Variety. The '4 Keys' option lets you set the order of the first 4 sort keys. This gives you finer control on how you want the data sorted. Search Start the Search by clicking on the Search button. Future | One Year For looking at what wines will be at their best in coming years. You can choose from next year to twenty years time. The Search button becomes a Next Dialog button. Click on this to bring up another Dialog Box which allows you to select the required year. Clicking on any year will start the Search.