Page 1 of 1

Individual details in fact query

Posted: 23 Dec 2018 13:38
by gsward
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')

Re: Individual details in fact query

Posted: 23 Dec 2018 16:05
by tatewise
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.

Re: Individual details in fact query

Posted: 23 Dec 2018 16:25
by gsward
Thank you, I guessed you would know the reason why! Now even better than I imagined.