Forskel mellem versioner af "Report: Show private notes"
Spring til navigation
Spring til søgning
Henny (diskussion | bidrag) (New page: Description: Show private notes Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT sta...) |
Ojay (diskussion | bidrag) m (Category added) |
||
Linje 7: | Linje 7: | ||
SELECT personID, lastname, firstname, birthdate, deathdate, living, note, p.gedcom FROM tng_people AS p INNER JOIN tng_notelinks AS nl ON (p.personID=nl.persfamID AND p.gedcom=nl.gedcom) INNER JOIN tng_xnotes AS xn ON (nl.xnoteID=xn.ID AND nl.gedcom=xn.gedcom) WHERE nl.secret<>0 ORDER BY lastname, firstname, birthdatetr | SELECT personID, lastname, firstname, birthdate, deathdate, living, note, p.gedcom FROM tng_people AS p INNER JOIN tng_notelinks AS nl ON (p.personID=nl.persfamID AND p.gedcom=nl.gedcom) INNER JOIN tng_xnotes AS xn ON (nl.xnoteID=xn.ID AND nl.gedcom=xn.gedcom) WHERE nl.secret<>0 ORDER BY lastname, firstname, birthdatetr | ||
-------- | -------- | ||
+ | |||
+ | |||
+ | [[Category:Henny Savenije - Reports]] |
Nuværende version fra 7. aug 2010, 05:39
Description: Show private notes
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
SELECT personID, lastname, firstname, birthdate, deathdate, living, note, p.gedcom FROM tng_people AS p INNER JOIN tng_notelinks AS nl ON (p.personID=nl.persfamID AND p.gedcom=nl.gedcom) INNER JOIN tng_xnotes AS xn ON (nl.xnoteID=xn.ID AND nl.gedcom=xn.gedcom) WHERE nl.secret<>0 ORDER BY lastname, firstname, birthdatetr