Jump to content
TNG Community
JPT

show status tag in tree view

Recommended Posts

JPT

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
Merv

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
JPT

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

×