* create subset including witnesses

[OlivierM]

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

[tatewise]

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.

image.png (90.09 KiB) Viewed 193 times

[OlivierM]

Wow ! Thank you .
I did really not imagine it would be that complicated.