Melle van der Heide Posted March 31, 2010 Report Share Posted March 31, 2010 How can I make a list of all living individuals with TNG. TNG made some of my individuals living which are long dead. I want to clean up my database, but I need to do it the hard way since I don't know this. Quote Link to comment Share on other sites More sharing options...
JackM375 Posted March 31, 2010 Report Share Posted March 31, 2010 How can I make a list of all living individuals with TNG. TNG made some of my individuals living which are long dead. I want to clean up my database, but I need to do it the hard way since I don't know this.You did not say what computer genealogy program you are using.I use Legacy v.7 and can do a Detailed Search with these settings:Primary Condition: Individual - Living - Equal To - YesSecond Condition: Individual - Birth Date - Before - 12/31/1910 (or what ever date you want).TNG has a setting for the oldest age for Living admin/setup/import setting I have mine set for 110 years old. This is also considering that there is a Birth Date. No Birth Date the person will be considered living. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted March 31, 2010 Report Share Posted March 31, 2010 How can I make a list of all living individuals with TNG. TNG made some of my individuals living which are long dead. I want to clean up my database, but I need to do it the hard way since I don't know this.Take a look at the Setup - Privacy article on the TNG Wiki. Maybe you need to change the setting for If no Birth Date Quote Link to comment Share on other sites More sharing options...
Melle van der Heide Posted March 31, 2010 Author Report Share Posted March 31, 2010 Windows XP/Vista, IE 6.0 or higher, TNG 7.1.2Do you use the commonly used user search function which can be found on the frontpage?I found the search function already! Administration->Find person->living only Quote Link to comment Share on other sites More sharing options...
Jerome Liebowitz Posted March 31, 2010 Report Share Posted March 31, 2010 I use the Living Flag Mod to see all the people listed as living. The only "problem" is that the mod works with descendant drop charts only, so that you have to go to the earliest ancestors for each line and then produce a descendant text chart. After that, it's easy to edit each individual incorrectly labeled as "living." Users (and visitors) without admin privileges do not see the "living" notationl.quote name='Melle van der Heide' date='Mar 31 2010, 05:15 AM' post='26765']How can I make a list of all living individuals with TNG. TNG made some of my individuals living which are long dead. I want to clean up my database, but I need to do it the hard way since I don't know this. Quote Link to comment Share on other sites More sharing options...
JackM375 Posted March 31, 2010 Report Share Posted March 31, 2010 This should be in the Reports forum:Report: A Report for living Ancestors Description: Maintenance - Report for living individuals. Code:SELECT tng_people.living, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,birthdate,if(sex='M',families1.marrdate,families2.marrdate),deathdate, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE (tng_people.living = 1) ORDER BY lastnameEnd Code:Put this Code in the bottom box Titled: OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.