List of trees with date of last change

[dbeezley]

I have more than 100 trees in my TNG site. All updates are done through GEDCOM via Ancestry. I want to see a list of the trees with the most recent change date. Please advise how I can create such a report.

[GOGGS]

From a different post on Saturday:

Try this:

 

select t.gedcom, t.description, treename, lastimportdate, count(personid) as numpeople from tng_people p inner join tng_trees t on p.gedcom = t.gedcom group by t.gedcom;

 

 

 

Cheers 

 

GOGGS

[dbeezley]

Thanks for the response. I will need more specific instructions, if you don't mind.

Where do I begin when selecting? I suppose it is in "Add New Report", but I don't see what to do then. I see "Choose Fields to Display", "Choose Criteria", "Operators", "Constant String", "Constant Value", and "Choose Sort Fields". There is also an option to "enter direct SQL SELECT statement." Am I close to where to begin?

Doug

[Leif Sweden]

19 minutes ago, dbeezley said:

Thanks for the response. I will need more specific instructions, if you don't mind.

Where do I begin when selecting? I suppose it is in "Add New Report", but I don't see what to do then. I see "Choose Fields to Display", "Choose Criteria", "Operators", "Constant String", "Constant Value", and "Choose Sort Fields". There is also an option to "enter direct SQL SELECT statement." Am I close to where to begin?

Doug

Doug, I tested in Report and it is working.

Coppy from GOGGS above and paste it in the lowest box in reports. Don´t forget Reportname and Description.

Leif

[dbeezley]

WOW! Excellent!