Citations with No Research Notes

#1 · 2021-08-15, 12:30 pm

I've been doing a major re-evaluation of my db. For a long time I have been putting extracted text from the source into the Research Notes field of the Citation.

I'm not the slickest at SQL. Is there a query that will find Citations with nothing in the Research Notes field of the Citation record and then link that with the Source record, the Event and then the person?

That would help me a lot.

Many thanks,

Rich

#2 · 2021-08-15, 1:50 pm

Yes. See Source List Query. The script for citations gives you all the info you need. Using SQLiteSpy, just click on any column header to sort it the way you want. For example, the Research Note is under the CitTxt column: sort on it to shove all the empty ones to the top or bottom.