Report: empty notes

From TNG_Wiki
Jump to navigation Jump to search

Description: empty 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 persfamID, note FROM tng_xnotes AS xn LEFT JOIN tng_notelinks AS nl ON nl.xnoteID=xn.ID WHERE note REGEXP "[print]|[punct]|[\.]| [\?]"=0 ORDER BY persfamID