* Individual details in fact query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
gsward
Famous
Posts: 144
Joined: 11 Mar 2011 14:47
Family Historian: V7

Individual details in fact query

Post by gsward » 23 Dec 2018 13:38

The solution in this post Individual details in fact query (6664) did not work for me in V6.

Rather than:
=GetField(FactOwner(%FACT%,1,MALES_FIRST),'%INDI.BIRT[1].DATE%')

these two entries added to the Columns section both worked a charm

Birth date:
=FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.BIRT.DATE')

Deathe date:
=FieldText(FactOwner(%FACT%,1,MALES_FIRST),'INDI.DEAT.DATE')

User avatar
tatewise
Megastar
Posts: 27087
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individual details in fact query

Post by tatewise » 23 Dec 2018 16:05

Yes, the Expression in that posting had a syntax error (now corrected) where the single quotes (') should have been double ("), i.e.
=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%") which does work.

However, =GetField(...) offers special extra features as explained in the Help that are not needed here.

Even better than =FieldText(...) is =Field(...) which presents the same data but is also a clickable link that opens the Birth or Death event in the Property Box.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
gsward
Famous
Posts: 144
Joined: 11 Mar 2011 14:47
Family Historian: V7

Re: Individual details in fact query

Post by gsward » 23 Dec 2018 16:25

Thank you, I guessed you would know the reason why! Now even better than I imagined.

Post Reply