Family Historian User Group

Not sure whether this topic has been done before, but I couldn't find anything about it after an hour or so of searching.

Anyway, I wanted a list of all events in my database which did not have a source attached to it - basically providing me with a list of events I needed to revisit and review.

I created a new custom query which I called "Events with no source" and made it a 'Fact' query type.

The query has 5 columns (defined in the Columns tab) as follows (shown as Heading – Expression – Sort):

Date – %FACT.DATE:COMPACT% – D
Event – =FactLabel(%FACT%)
Individual 1 – =FactOwner(%FACT%,1,MALES_FIRST)
Individual 2 – =FactOwner(%FACT%,2,MALES_FIRST)
Place – %FACT.PLAC%

I then added 2 filters (in the rows tab) as follows:

Add if =IsEvent(%FACT%) is true
Exclude if =Exists(%FACT.SOUR>%) is true

The result is a report showing all Events which don't have a source attached to them, along with the individuals (or Husband and Wife in the case of family events), all sorted in descending date order (i.e. the most recent first).

Personally, I've found this very useful, especially when I've been looking to tidy up my family tree and see where I first added entries but forgot to add the source details (due to newbie genealogical naivety!)

I have a similar custom query, but instead of two columns for Individual 1 and Individual 2, I have just one column for Fact Owner using the much simpler expression =GetRecord(); it works fine for Family as well as Individual Facts.

Check the fhugdownloads:contents:unsourced_facts|> Query:Fact ~ Unsourced Facts Query that is very similar but includes Attributes as well as Events.