Help needed on queries
|
David Anderson
Hi,
I wanted a simple list in FH - what surnames are associated with Suffolk. Sadly my foray into queries left me totally confused! Can anyone help with how to set up this query? Regards David |
|
|
|
Brian Horridge
David
toggle quoted message
Show quoted text
Why not use the 'Contains text' query. It might pick up any Suffolk used as a name or street name but may not be too many of them. Brian Sent via BT Email App From: David Anderson <dma@...>
Sent: 14 February 2023 16:18:33 GMT+00:00 To: family-historian@groups.io Subject: [family-historian] Help needed on queries Hi, I wanted a simple list in FH - what surnames are associated with Suffolk. Sadly my foray into queries left me totally confused! Can anyone help with how to set up this query? Regards David |
|
|
|
Paul Tanner-Tremaine
Try new query - call it Persons in a County
Under Rows Add if Expression : %INDI.BIRT[1].PLAC>% Operator : contains tick the parameter box Label : County Add and run it. That will prompt for the County, and return all who have the County in their Birth Place. You can change it from a parameter using the Value instead of the Parameter and forcing it to Suffolk. You could then add further Rows check for marriage place, death place, residence, etc to get a complete picture. I would add the columns for each type so you know where the data came from. |
|
|
|
Follow the previous advice but also look at my video and expressions below and jump in around TCR 4:41 I'm not in front of FH but this query was designed to report any person with an association to the defined place and I believe includes mentions in Notes. On Tue, 14 Feb 2023, 16:18 David Anderson, <dma@...> wrote: Hi, |
|
|
|
David, It is not possible with a Query to just list unique Surnames. A Query can only list the full names of people.
What exactly do you mean by “associated with”? Unfortunately, a Query cannot deal with that kind of ‘fuzzy’ logic. Do you mean Born in the county, or was Married or Died in the county, or perhaps had any fact recorded in the county?
To differentiate a county (in Britain?) from any other similar Place name part needs consistent Place names. Are all your Place name fields arranged such that they all end with a county and a country separated with a comma? Then you could use the ‘ends with’ Operator in the Rows tab filter of the Query.
You could start with the FHUG Knowledge Base Download Fact Query ‘Add Facts Filter by Label’ https://fhug.org.uk/kb/download/all-facts-filter-by-label/ On the Rows tab change the Expression to %FACT.PLAC%, the Operator to ‘ends with’ and the Label to ‘County’.
|
|
|
|
An alternative approach - not using queries ...
Find (on the toolbar) > type "suffolk" > Find Now > Display Results in Results Window > Sort colums as desired. Save as a PDF, or as a CSV to open in a spreadsheet. Should catch all instances of Suffolk, including baptisms, burials, census, wills, probate etc. |
|
|
|
Yes, but it would be better to use Suffolk, England and tick the Match case and Match whole word options. Otherwise, it may find ‘suffolk’ in USA or in other Place name parts such as South Suffolk Farm. Bear in mind that it will list all matching Place records that need to be omitted from the output.
An alternative approach - not using queries ... _._,_._,_ |
|
|