Tinker's Gardens Database CustomQuery

broadband dialup

 

CustomQuery How To

This search feature is designed for maximum flexibility and maximum power.  It uses standard SQL syntax.  The "SELECT * FROM ahs_main WHERE (" section of the SQL query statement is built into the application, so there is no need to enter it.  Enter the WHERE clause in the data entry field provided above.  Below is a summary of the fields held in the ahs_main table and other options to use in your custom query. Example Queries: With one search item: PL like 'TET' With two search items: Year >= 1800 and SSM <> '' With three search items: Diam > 5 and form like 'sp' and ht > 30 With three major search items, two comprised of minor search items: Hybridizer like 'Stamile P' and (Year = 1999 or Year = 2000) and (Color like '%blue%' or Color like '%lavender%') CULTIVAR should be entered as Cultivar like 'Cultivar Name'. % is the wildcard character and can be used in any "Text" field and is to be used between the single quotes ( ' ) . HYBRIDIZER should be entered as Hybridizer like 'Hybridizer Name'. % is the wildcard character and can be used in any "Text" field and is to be used between the single quotes ( ' ) . YEAR should be entered as YEAR = 1995. The following operators can be used: Operators = Equal to <> Not equal to > Greater than < Less than >= Greater than or equal to <= Less than or equal to PL (ploidy)  should be entered as PL like 'TET'. DIP - Diploid TRI - Triploid TET - Tetraploid   CHI - Chimera HT (height) should be entered as HT = 30 in inches only.  You can use any of the operators listed above. Diam (Diameter) should be entered as  Diam = 5.5 in inches only.  You can use any of the operators listed above. Season should be entered as Season like 'Early' Early Early Early Early Mid Mid Mid Late Late Very Late Habit should be entered as Habit like 'Evergreen' Evergreen Semievergreen Dormant Branching should be entered as BR = 5.  < or > may also be used. Note: Branching data is only available for 2004 registrations; therefore all results will be 2004 registrations. Bud Count should be entered as BC = 10.  < or > may also be used. Note: Bud Count data is only available for 2004 registrations; therefore all results will be 2004 registrations. Color/ Description should be entered as colordesc like '%bi%'. Because of the wide range of inconsistencies in the way color data is described by the hybridizers it is beneficial to always encapsulate your color search term in wildcards.  Please note that you should use the following abbreviations: apricot = apr burgundy = burg chartreuse = chart cinnamon - cinn cream = cr dbl = double eye zone = ez green = gr lavender = lav light = lt medium = med midrib = mr nasturtium = nasturt polychrome = poly red = r throat = thr violet = viol warm = wm white = wh with = w yellow = yell FRAG (Fragrant) should be entered as FRAG like 'Fragrant'. Fragrant Very Fragrant Tip: the best way to append a search for fragrant cultivars to a query is as FRAG <> '' NOC (Nocturnal/ EMO) should be entered as NOC <> '' or NOC = ''. N or noc - Nocturnal Tip: the best way to append a search for nocturnal or diurnal cultivars to a query is as: Nocturnal: NOC <> '' Diurnal: NOC = '' EXT (Extended Bloom) should be entered as EXT <> '' or EXT = ''. E or ext - Extended Bloom Tip: the best way to append a search for extended bloom or non-extended bloom cultivars to a query is as: Extended Bloom: EXT <> '' Non-Extended Bloom: EXT = ''   Form should be entered as Form like 'sp'. Dbl - Double Poly - Polytepaloid (usually joined with another form as 'Poly/sp' or 'sp/Poly' Sp - Spider Ufo - Unusual form Ratio should be entered as (Ratio > 4.34 and Ratio < 6.2) Parentage should be entered as Parentage like '% X MAUNA LOA' For primary parentage enter as  % X Cultivar Name  or as Cultivar Name X %.  For secondary parentage enter as %XCultivar Name% or %Culivar NameX%. To show only cultvars with a known parentage append the following search to your query Parentage <> 'Not Available' To avoid parentages containing Sdlg use  Parentage not like '%Sdlg%' SSM (Stout Silver Medal) As of 2006 SSM data is no longer part of the ahs_main database table and therefore is not searchable from the custom query page.