| Go to the Lookup Page | Family Tree Home | Home |
|
The selection criteria is specified as a Structured Query Language (SQL) where clause. Don't panic! In it's simplest form, this is just some very easy boolean logic. For example, First='John' will cause all persons with a first name or John to be selected and displayed. Columns or Fields that may be targeted. Last This is the Last Name field or the reference key value when the entry is not a person. For example, Last='Smith' would select all the index items that equal Smith in the Last field. Last is an alphanumeric field and you must always use the single quotes around the value you are seeking. First This is the First Name field. In general, if the entry does not represent a person, this field will be empty. For example, last='Smith' and First='John' would select all the John Smiths in the index. Please note: This would not select John A. Smith or John Jr. Smith. This type of query only supports exact matches (see below). However, case doesn't matter, so First='John' and First='john' would produce the same results. AID This is the Ancestor ID field. Individuals are assigned a unique ID, so using the AID will select all records for a person regardless of name variations such as Sytie Dewees and Zythian Dewees. For example, AID=41 would select the above reords. Note that AID is numeric. No quote marks are required or allowed. Volume This is the Newsletter Volume number. This is numeric and ranges from 1 to 9. Issue This is the Newsletter Issue number. This is numeric and ranges from 1 to 6 for volumes 1&2 and 1 to 4 for volumes 3-9. For example, Volume=1 and issue=4 would essentially reproduce the index from the 4th newsletter. Page This is the Page number. Page numbers are unique throughout the newsletter. Page 83 is in issue 3 of volume 1. |
Order by Select one of the built-in display orders. If anyone has any suggestions for additional output order, email me. |
Advanced Selections You can 'and' and 'or' the basic selection criteria together. For example: (Last='Deweese' or Last='Dewees') and (First='Lewis' or first='Lambert') would select all Lewis and Lambert Dewees regardless of the spelling of the last name. not (AID=41) selects all but AID 41 (the same as AID <> 41). Some other stuff: Volume in (1,3,7) is the same as Volume=1 or volume=3 or volume=7. The Lewis/Lambert query could also be written as Last in ('Dewees','Deweese') and first in('Lambert','Lewis'). The above examples all specify exact matches. What if you want to get all Johns, Dr. John, Mrs. John, and so on? Try First like'%John%' . To get all last names starting with S, enter Last like 'S%', i.e. the % is a wild-card. To get all last names starting with S, and John anywhere in the first name enter First like '%John%' and Last like 'S%'. Email me if you have a query in mind that you can't formulate. |