TMG-L ArchivesArchiver > TMG > 2001-11 > 1006186559
From: "John Cardinal" <>
Subject: RE: [TMG] How to Filter for Witnesses?
Date: Mon, 19 Nov 2001 11:15:59 -0500
Let me see if I understand what you asked.
You want to set a custom flag called UNCONNECTED to Y or N based on whether or
not people have no connections to other people in your DB. (I'd suggest you
change the flag name to CONNECTED and reverse the meaning of Y and N--it's less
You wrote an LOP to set everyone as connected ("N"), and then a second LOP to
find the unconnected people and set them to Y. The criteria for your second LOP
FATHERS ID = 0 AND
MOTHERS ID = 0 AND
NUMBER OF SPOUSES = 0 END
When you reviewed the results, people who were connected, but not by birth or
marriage, were set to Y. Specifically, in two cases, people who were witnesses
to events of connected people were set to Y. So--you want advice on how to
modify the criteria to include those people.
You'll note that I have expanded the problem beyond only witnesses. That is one
problem, but actually, any one who is not connected by birth or marriage,
including witnesses or principals to other events, will not be set the way you
Have I got it right?
If I do, the problem is that I don't know the answer <g>. The criteria needs to
eliminate people who share events (either as principals or witnesses) with other
people. I'm not a CRW expert--maybe someone else who is will pipe in. I could
fumble around a bit; the answer might involve multiple "Any Tag -- XXX Group --
Does Not Exist" but I am not sure how to find events shared with another
principal, witnessed or not.
Jerry Cahill wrote:
> My message of last week asking how to filter for "witnesses" got turned into
> a discussion of "sperm donors" without an answer to my question. Can someone
> answer or make some suggestions on the original question?