* All empty facts query
-
- Diamond
- Posts: 55
- Joined: 03 Aug 2011 16:26
- Family Historian: V7
- Location: Winscombe, England
All empty facts query
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.
- tatewise
- Megastar
- Posts: 28436
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: All empty facts query
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.
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
-
- Diamond
- Posts: 55
- Joined: 03 Aug 2011 16:26
- Family Historian: V7
- Location: Winscombe, England
Re: All empty facts query
Thank you Mike.