* Fact Query for Electoral Roll help please

[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!

[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", "?" )

[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

[StevieSteve]

Forgot there was football on, but have given it a quick try this morning and works as hoped for

Thanks Mike

[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.

[AdrianBruce]

... 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.

[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