TNG - Tips & Tricks
Working with TNG's SQL-based Reports (A Guide to my Report Library)
Please read first
- Go to my reports page. Remember (or write down) the name (R.....)
of the report which you would like to enter on your own TNG website.
- Locate and run the appertaining "RR" report to
obtain the requested report definition.
Example: If you want the definition of RFC211
(the "twin report"), you have to run the RRF001
report from my reports page.
- Read the additional (report-specific) documentation which
comes with the "RR" report's result. Copy the report
definition (beginning with SELECT...) into your clipboard.
- Enter the administration area of your TNG website. Goto
"reports", create a new report and paste the definition
(from step before) into the SQL field. Type in a report name and
description. Save the new report.
- Test the report. If everything works fine, make the report public
(if you like).
Privacy issues
Be careful with reports on living people's data! Some of
my reports have the "living" field included. If you remove
it, living people's data in the report output will be visible to the
public! As long as the "living" field is part of the report
definition, users who are not logged in can't see any living people's
data. (Test it on your own before making the report public!)
Modifying Report Definitions, Creating Your Own Report Definitions
- For developing and testing your own SQL statements, you can use
the MySQL Workbench (to be
installed on your computer) or phpMyAdmin (to be installed
on your website; maybe your web provider has it already done).
- MySQL documentation (Reference Manual): see http://dev.mysql.com/doc/; Chapters
"Language Structure", "Functions and Operators",
"SQL Statement Syntax" (-> SELECT!).
Copyright © http://www.ahnendaten.de/tng/
Letzte Aktualisierung am 11. Juni 2017