Hello to all,
I want to create a subset of my database like "all the relatives of" but this does not show the witnesses of these relatives. I tried a lot of queries, but did not find any that includes the witnesses.
How should I achieve this ?
Thank you,
Olivier
* create subset including witnesses
-
- Famous
- Posts: 104
- Joined: 30 Jan 2023 04:33
- Family Historian: V7
- Location: Brussels
- Contact:
create subset including witnesses
I started with Reunion > 30 years ago, later TMG.
I now use FH as main software, TNG to share my data.
Transkribus to decipher old texts.
Genealogica Grafica, TCGB and My Family Tree to view & check my data. And Genopro for its layered reports.
I now use FH as main software, TNG to share my data.
Transkribus to decipher old texts.
Genealogica Grafica, TCGB and My Family Tree to view & check my data. And Genopro for its layered reports.
- tatewise
- Megastar
- Posts: 28488
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: create subset including witnesses
Yes, it is quite involved. This is how I would attack this problem.
First, populate a Named List with "all the relatives of" subset.
Now you need an Individual Query that finds every Witness whose Principal is in that Named List.
To find whether an Individual is a Witness there is a special shortcut %INDI.~SHAR>% that points to the Fact.
See the Help for Data References
To find the Principal of that fact use FactOwner( %INDI.~SHAR>%, 1, MALES_FIRST )
But Family facts have a 2nd Principal FactOwner( %INDI.~SHAR>%, 2, MALES_FIRST )
See the Help for Functions.
Test if Principal is in Named List using =IsInList( FactOwner(%INDI.~SHAR>%,1,MALES_FIRST), "Bookmarks" )
Repeat that for the 2nd Principal. Use whatever Named List you chose for the subset.
Now some Individuals may be a Witness to many, many facts so those two expressions must be repeated for instances %INDI.~SHAR[2]>%, %INDI.~SHAR[3]>%, %INDI.~SHAR[4]>%, and so on...
Run the Query and in the Resut Set select all the Individuals and add them to the Named List subset.
e.g.
First, populate a Named List with "all the relatives of" subset.
Now you need an Individual Query that finds every Witness whose Principal is in that Named List.
To find whether an Individual is a Witness there is a special shortcut %INDI.~SHAR>% that points to the Fact.
See the Help for Data References
To find the Principal of that fact use FactOwner( %INDI.~SHAR>%, 1, MALES_FIRST )
But Family facts have a 2nd Principal FactOwner( %INDI.~SHAR>%, 2, MALES_FIRST )
See the Help for Functions.
Test if Principal is in Named List using =IsInList( FactOwner(%INDI.~SHAR>%,1,MALES_FIRST), "Bookmarks" )
Repeat that for the 2nd Principal. Use whatever Named List you chose for the subset.
Now some Individuals may be a Witness to many, many facts so those two expressions must be repeated for instances %INDI.~SHAR[2]>%, %INDI.~SHAR[3]>%, %INDI.~SHAR[4]>%, and so on...
Run the Query and in the Resut Set select all the Individuals and add them to the Named List subset.
e.g.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
- Famous
- Posts: 104
- Joined: 30 Jan 2023 04:33
- Family Historian: V7
- Location: Brussels
- Contact:
Re: create subset including witnesses
Wow ! Thank you .
I did really not imagine it would be that complicated.
I did really not imagine it would be that complicated.
I started with Reunion > 30 years ago, later TMG.
I now use FH as main software, TNG to share my data.
Transkribus to decipher old texts.
Genealogica Grafica, TCGB and My Family Tree to view & check my data. And Genopro for its layered reports.
I now use FH as main software, TNG to share my data.
Transkribus to decipher old texts.
Genealogica Grafica, TCGB and My Family Tree to view & check my data. And Genopro for its layered reports.