Is there a way to mark all living as private?

[camfam]

I want to take a look at GEDmatch, but I want to mark all Living people in my TNG as Private before I export my TNG GEDCOM. Is there a way to mark all Living people as Private in TNG at once instead of doing it one by one in each person's profile?

[camfam]

I solved this by editing the database directly with the following SQL:

UPDATE tng_people
SET private = 1
WHERE living = 1;

[camfam]

Just now, camfam said:

I solved this by editing the database directly with the following SQL:

UPDATE tng_people
SET private = 1
WHERE living = 1;

I'm sure that you could do the same by creating a report with the SQL.

[Katryne]

Would this mod do the job ?

https://tng.lythgoes.net/wiki/index.php/Living_Flag_Backup_/_Restore