Page 1 of 1
Fact Query for Electoral Roll help please
Posted: 19 Jun 2016 22:11
by StevieSteve
Hi. I'm trying to create a query to find individuals who might be on the Electoral Roll
I have produced a result set with
Code: Select all
Date: %FACT.DATE%
Fact: =FactLabel(%FACT%) matches Census or Residence
Fact Owner: =FactOwner(%FACT%,1,MALES_FIRST)
Fact Owner Age: =AgeAt(FactOwner(%FACT%,1,MALES_FIRST),%FACT.DATE%)
Place: %FACT.PLAC%
Address: %FACT.ADDR%
Now I want to get the sex of the Fact Owner
Looking at the Boys' Names standard Query, I have been trying to adapt
%INDI.SEX% matches male
but I can't seem to replace INDI with any combination of FactOwner(%FACT%,1,MALES_FIRST), % and =
Can someone let me know what I'm doing wrong please
Thanks!
Re: Fact Query for Electoral Roll help please
Posted: 20 Jun 2016 08:46
by tatewise
Stevie, (if necessary) please use this FHUG User Control Panel > Profile to update your Family Historian Version that displays to the right of your postings.
The trick with getting fields like %INDI.SEX% is to use the =Field...(...) and =GetField...(...) functions.
e.g.
=FieldText( FactOwner(%FACT%,1,MALES_FIRST), 'INDI.SEX' )
BTW: A neater way to get the Fact Owner is =GetRecord(%FACT%) but remember for Family Facts such as Marriage this will return the Family Record not the Individual Husband Record.
e.g.
=FieldText( GetRecord(%FACT%), 'INDI.SEX' )
BTW: In this special case of SEX there is a useful FH V6 function where you choose what text you want for the SEX cases.
e.g
=Sex( GetRecord(%FACT%), "m", "f", "?" )
Re: Fact Query for Electoral Roll help please
Posted: 20 Jun 2016 11:25
by StevieSteve
Call me a Luddite, Mike, but I still am on V5
Thanks for the answer, I'll try it out tonight when I get home
Re: Fact Query for Electoral Roll help please
Posted: 21 Jun 2016 07:50
by StevieSteve
Forgot there was football on, but have given it a quick try this morning and works as hoped for
Thanks Mike
Re: Fact Query for Electoral Roll help please
Posted: 25 Jun 2016 19:24
by jmurphy
At the risk of further complicating things --
Re: filtering for gender -- Women might appear in electoral rolls in England because they qualify to vote in local elections, and their entries might persist after the death of their spouse. Someone who is collecting all of the entries for a family might want to locate those entries as well. I suppose a very thorough query might build in exclusions for dates before which women won't appear, but if you apply the more restrictive constraints across the entire dataset, you'll be missing search opportunities.
Re: Fact Query for Electoral Roll help please
Posted: 25 Jun 2016 22:35
by AdrianBruce
jmurphy wrote:... exclusions for dates before which women won't appear, ...
That could be quite tricky. Without cross-checking, I think the story is quite complex. Somewhat accidentally, I think, some women did have the vote in the early years but one of the major Franchise Extensions "clarified" that women couldn't vote. Then they got the vote back for certain types of poll much later on, (e.g. local elections, as Jan says) - but with a different qualifying age from the men.
Re: Fact Query for Electoral Roll help please
Posted: 28 Jun 2016 08:04
by StevieSteve
Thanks for the thoughts.
I'd ruled out being able to code a query for finding widows and spinsters with a residence or census fact pre-1918, purely down to my skill-level.
Based on no evidence at all, I think the number of false hits I'd get would greatly outweigh the true ones