Category:Reports
Jump to navigation
Jump to search
TNG Reports
TNG Reports
This page needs expansion and has the following purposes:
- Listing of generic reports constructed in such a way that any TNG novice could be successful at creating and using the reports query
- Hopefully in time all TNG users will benefit by being exposed to SQL SELECT code and learn from the collective successes of other users.
Many, but not all, of these queries can be run in the TNG Reports tool. Some queries must be run in phpMyAdmin, or a similar program.
- For detailed information and instructions on using the TNG Reports function refer to pages listed in the next section, or go directly to the TNG Reports page.
- See also SQL-The Least You Need To Know.
Sites with multiple trees
Not all of these queries are written to deal with multiple trees. You may need to modify some of them to take trees into account. [Show How]
- Frequently, all you need to do is specify the treeID in the query's WHERE clause. For example, you might need to change
WHERE lastname="SMITH"toWHERE lastname="Smith" AND gedcom="BobsTree"
- You will almost surely want to make sure that linked records are in the same tree as each other. For instance, if you want to display the name of the wife in a Family records, you'll need to compare the two gedcom fields to each other like this:
... FROM tng_families f INNER JOIN tng_people w ON w.personID=f.wife AND w.gedcom=f.gedcom.- Significantly, many of the queries defined here already include a gedcom field comparison like this, even if they omit other considerations of having multiple tree. Omitting the gedcom field comparison can slow down a query considerably.
- To display the treeID in its own columns, just start the SELECT clause with x.gedcom (where x represents the table alias of any of the tables in the query), e.g. change
SELECT personID, lnprefix, lastname, firstname, burialdate, burialdatetr FROM tng_people...toSELECT gedcom, personID, lnprefix, lastname, firstname, burialdate, burialdatetr FROM tng_people...
- To show results from all trees and sort the results by treeID, you may need nothing more than an ORDER BY clause such as
ORDER BY x.gedcom
[Hide Details]
Subcategories
This category has only the following subcategory.
H
Pages in category "Reports"
The following 26 pages are in this category, out of 26 total.
M
- Maintenance - Custom Event Media Links
- Maintenance - Headstone to Cemetery Links
- Maintenance - Place Level = 2
- Maintenance - Places - Zoom & Place Levels
- Maintenance - Places with identical geocodes
- Maintenance - Places with no Events
- Maintenance - Places with no maps
- Maintenance - Pooled Places with no Events
- Maintenance Reports
- Marriage: Death to Next Marriage-Report
- Mass Updates of Place and Zoom Levels Using Reports
R
- Report: Census summaries for families
- Report: Children with Spouse and Parents
- Report: FindaGrave Citation Worklist
- Report: Number of Deaths in year-ranges
- Reports
- Reports - Auswertungen
- Reports - Auswertungen/de
- Reports - Custom Events (Creating)
- Reports - Learning How To Create
- Reports - Most Wanted (Creating)
- Reports - Notes
