* All empty facts query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
Pentris
Diamond
Posts: 55
Joined: 03 Aug 2011 16:26
Family Historian: V7
Location: Winscombe, England

All empty facts query

Post by Pentris » 28 Jan 2022 11:23

Is there any guidance available as to how to use the 'All empty facts' query. When I run it I get an error message 'This query contains one or more disabled column or row filters. Continue anyway' If I continue it produces nil results for 'Facts and events' group. I know that I have many facts which for some reason I have omitted to enter a date. I would like to be able to find them and correct the situation.

User avatar
tatewise
Megastar
Posts: 27082
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: All empty facts query

Post by tatewise » 28 Jan 2022 12:03

The Knowledge Base Download page All Empty Facts says it is for FH versions: V4, V5, and V6 so is not FH V7 compatible.

The first sentence says "Finds all Facts without any subordinate fields. i.e. No Date, Age, Place, Address, Cause, Note, Media, Citation, etc, etc."

So if your Facts with no Date have any of those other subordinate fields then the Query won't find them.

The only Rows tab Filter that is relevant for your no Date case is:
Exclude unless =NullDate(%FACT.DATE%) is true

So if you copy and rename that Query and delete all the other Filters it will find your empty Date Facts.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Pentris
Diamond
Posts: 55
Joined: 03 Aug 2011 16:26
Family Historian: V7
Location: Winscombe, England

Re: All empty facts query

Post by Pentris » 28 Jan 2022 12:36

Thank you Mike.

Post Reply