Jump to content
eilenej1

Filter Question

Recommended Posts

I have several people in my project who have no death event, but they're definitely dead. I want a list of these people so I can begin searching for their death data. I've attempted to filter a list of people as follows:

 

1st line of Filter

Field Age Today

Operator > Is greater than

Value 100

 

2nd line of Filter (connected with an "And")

Field Death...

Sub Field # of tags

Operator = Equals

Value 0

 

This returns a list of people with a death tag, when I really want people over 100 as of today with NO death tag.

 

Any ideas?

 

Eilene

Share this post


Link to post
Share on other sites

I came at your question this way:

 

"Birth" "Date" "< comes before" "1906" "AND"

 

"Birth" "Date" "> comes after" "1896" "AND"

 

"# of Death Group tags" "= Equals" "0" "END"

 

This limited my birth date range to possible living people, since I have lots of people in my datasets that don't have death dates, but were born a couple hundred years ago. The use of the death group tags would catch any custom tags in that group, as well. I still got 117 people from a project of 5551 people, but that is because I am working on descendants of rather than ancestors of.

Share this post


Link to post
Share on other sites

I use the following to change the LIVING flag to N:

 

Any Event Year <= Is before 1890 AND

(Living Flag = Equals Y OR

Living Flag = Equals ? ) END

 

I used Any Event because sometines I only have their children's birth date, not theirs.

 

After you do this, you can run an LOP for people whose Living flag is N and the # of tags in the Death Group is 0 and you will get your list of those for whom you need a death date/place.

 

This should pick up most of them...

 

Jan

Share this post


Link to post
Share on other sites

Well, this did not work! I just checked and tons of people who are living are picked up by the first filter. It appears that any undated tag fits this! What a mess!

 

Back to the drawing board!

 

Jan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×