* Query to identify Stillbirths

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
User avatar
AdrianBruce
Megastar
Posts: 1961
Joined: 09 Aug 2003 21:02
Family Historian: V7
Location: South Cheshire
Contact:

Query to identify Stillbirths

Post by AdrianBruce » 20 Apr 2023 16:32

If I use the "Age" facility against the Birth event and enter "Stillborn", I can see on the All tab that the Age (under the Birth event) contains "Stillborn".

How can I use that in a query to identify children who have been stillborn?

If I try to test %INDI.BIRT[1].AGE% for equals "Stillborn", it turns it into a test for equals zero. But that doesn't work when I try to use a single filter of Add if %INDI.BIRT[1].AGE% equals 0, because I don't see any of the 3 individuals that I know to be stillborn and marked as such. In fact, I don't see anyone in the results set.


Slightly confused here... :?
Adrian

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

Re: Query to identify Stillbirths

Post by tatewise » 20 Apr 2023 20:00

Yes, the Query is not very helpful and you have to think outside the box and use the equals operator.

=IsTrue( %INDI.BIRT.AGE% = "Stillborn" )

i.e. Add if =IsTrue( %INDI.BIRT.AGE% = "Stillborn" ) is true
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
AdrianBruce
Megastar
Posts: 1961
Joined: 09 Aug 2003 21:02
Family Historian: V7
Location: South Cheshire
Contact:

Re: Query to identify Stillbirths

Post by AdrianBruce » 20 Apr 2023 20:21

Thanks very much for that Mike. Works fine.

It sort of looks to me like that coding is getting to the %INDI.BIRT.AGE% before the clever stuff turns "Stillborn" into zero - I found =AgeAt(%INDI%,%INDI.BIRT.DATE%) gave an answer of zero for the three that I knew of.
Adrian

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

Re: Query to identify Stillbirths

Post by tatewise » 20 Apr 2023 20:48

Adrian, you are overthinking it.
There is no clever stuff ~ the Age value really is "Stillborn" and remains as "STILLBORN" in the GEDCOM.
i.e.
1 BIRT
2 AGE STILLBORN

=AgeAt(%INDI%,%INDI.BIRT.DATE%) returns 0 for everybody.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply