Queries – Page 3 – Family Historian User Group

Sub Categories

ONS – [given] census in [place]: One-Name Study query selecting Individuals who appear in census records for a specific place
ONS – [given] child of [given]: One-Name Study query selecting Individuals by the given name(s) of their father or mother
ONS – [given] married to [given]: One-Name Study query selecting married couples by their given names
ONS – [given] sibling of [given]: One-Name Study query selecting Individuals by the given name(s) of one of their siblings
ONS – [surname] married to [surname]: One-Name Study query selecting married couples by their surnames
Parent Ages: Lists Individuals sorted by name, whose birth occurred when either parent was potentially too young (<16), or old (father >65 or mother >50), or may have already died
People at a Place before 1837: Lists all the people who have a primary life event – currently includes Birth, Baptism, Christening, (first) Marriage, Death, Burial – that is recorded at an identified PLACE (not Address or Residence) e
People Linked to Source: Lists people linked to a Source, which have been changed since a specific date
Person Existence Check: Enter a “Surname” and “Forename” and this Query Lists all people who match
Pinpoint by Location: This identifies relevant Records by reviewing Name (or part of Name), a Birth year range and location, such as a Place name (or part of a Place name)
Pinpoint Using Parents: This identifies relevant Records by reviewing Parents’ names in a large dataset containing many individuals with the same name and/or variant surnames
Places: This query allows the selection of a “Place” and then displays all individuals who have life events – Birth, Baptism, 1st Marriage, Death, Burial – in that Place
Places of Burial: Lists all individuals with a Burial event where a Place is present
Private Flag is Set: Query to select all persons with the Private Flag Set – useful for using with Mark and Select on Diagrams to hide Private people
Query and Spreadsheet: Multimedia File Links: This download is intended to help manage broken File Links in conjunction with
Ready for Census 1921: This query allows you to create a list of those ancestors with a specified surname who might appear in the 1921 Census
Record IDs (Superseded): Simple Query sorting individual records by Custom Id and standard Record Id, as well as listing Automated Record Id and Permanent Record Number
Records Window with Parents: Simple Query showing both Parents Preferred Names
Records Window with Spouse Surname: Individual Records Window based Query columns as per the installation configuration, but with additional “Spouse Surname” column
Redundant Families: This query will find Family Records with no parents and only one child attached
Relations – Same Generation: Simple custom query to list all the relations who are in the same generation as a specified person
Search For Orphans: This is based on the standard Search For Orphans Query, but only lists records that have no Family as Child and no Family as Spouse information recorded
Single Surname: Lists all people that match exactly with a selected “Surname”
Sort by Initials: Query to sort Individuals by their First and Middle names, where the initials match “First Initial” and “Middle Initial” parameter prompts
Sources for Repository: Shows all Source Records for a selected Repository Record
Surname Pairs: Prompts for two Surnames and lists all people who have one of the Surnames and married someone with the other Surname
Surname Summary: This custom query finds all Individuals that match a particular “Surname” parameter, and lists Spouse, Father, Mother, Birth Date, and Birth Place (where known) for each person
Timeline Facts – Overview: This page covers a series of a single Standard Query, and 6 similar Custom Queries which attempt to produce a genealogical timeline of facts spanning the lifetime of a chosen person
Timeline with Most Relatives: Picks up all facts from most relatives of the key start person, where the facts happened in that persons life time
Timeline with Most Relatives and Named List: Picks up all facts from most relatives of the key start person, where the facts happened in that persons life time
Timeline with Near Relatives: Picks up all facts from people “closely” related to the key start person, where the facts happened in that persons life time
Timeline with Near Relatives and Named List: Picks up all facts from people “closely” related to the key start person, where the facts happened in that persons life time
To Do Lists: The Fact Set creates a Custom Attribute in which the Note field holds labelled details of Work In Progress or Research To Do for the associated Individual
Unsourced Facts: This query will show all Facts that do not have a Source citation
Used Names: Identifies all individuals where the Name Used field is completed – for use when the first given name cannot be recalled
WebClean: This query selects people to be excluded from a Family Tree CD or Website by using the option:- SELECT > REMOVE USING QUERY It attempts to list all living people, except descendants of up to 4 individuals, who have granted permission to go public
Wedding Anniversaries: This lists married couple details where there is a wedding date and both partners have no death information
WW1 Possibles: This is a query to select those Males who were under 50 in 1914 or over 16 by 1918 and may, therefore, have enlisted for Service during World War 1
X Married to Y: Find married couples, where the Name of one Spouse contains the “1st Name” provided, and the Name of the other Spouse contains the “2nd Name” provided