Jump to content
TNG Community

show status tag in tree view

Recommended Posts


I am planning to add a short text about the person's data status into the STAT tag. Would be nice to see that in a tree overview. any ideas of how to add that?

Share this post

Link to post
Share on other sites

Hi, I'm not exactly sure what you are after, but maybe set up STAT as a custom event (if you haven't already) and then make a report that shows all the STAT tags in your tree/database.

Share this post

Link to post
Share on other sites

Thanks for the idea.

solved it:

SELECT p.personid, p.gedcom, eid.info as AhnenID, 
	p.firstname, p.lastname, 
	p.birthdate, p.birthplace,
	f.marrdate,  f.marrplace,
	p.deathdate, p.deathplace,
	es.info as Status
FROM tng_people p
INNER JOIN tng_families AS f ON (f.husband=p.personID or f.wife=p.personID) AND p.gedcom=f.gedcom
INNER JOIN tng_events eid ON eid.persfamid = p.personid and eid.gedcom = p.gedcom and eid.eventtypeid = 15
LEFT JOIN tng_events es  ON es.persfamid  = p.personid and es.gedcom  = p.gedcom and es.eventtypeid = 20
ORDER BY p.gedcom, AhnenID;

this script expects eventtype 15 containing an ID and eventype 20 to contain the status. if you want it to work regardless if you have these tags, replace INNER with LEFT for the second join.

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