I use the query Unsourced_Facts to track any changes that have not been fully sourced. Since FH5 now adds Ancestor Count and Descendant Count these appear as unsourced facts. I therefore have hundreds of entries in the query report making it difficult to see the wood from the trees. Could someone with knowledge of writing queries please produce a new version with 'Ancestor Count and Descendant Count' excluded.
Regards
Robin Dew
ID:6151
* Query update
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Query update
I assume you have used the Create and Update Ancestor and Decendant Counts Plugin.
A quick solution is to run the Plugin and Delete all the counts before using the Query.
The counts can always be put back by running the Plugin again with the Create option.
Alternatively Add the following two Rows tab Filters to the Query:
Condition: Exclude if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Ancestor Count
Condition: Exclude if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Descendant Count
A quick solution is to run the Plugin and Delete all the counts before using the Query.
The counts can always be put back by running the Plugin again with the Create option.
Alternatively Add the following two Rows tab Filters to the Query:
Condition: Exclude if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Ancestor Count
Condition: Exclude if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Descendant Count
-
Pentris
- Diamond
- Posts: 55
- Joined: 03 Aug 2011 16:26
- Family Historian: V7
- Location: Winscombe, England
Query update
Thank you Mike. That has worked a treat.