Page 1 of 1
Query update
Posted: 16 Apr 2012 16:07
by Pentris
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
Posted: 16 Apr 2012 20:54
by tatewise
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
Query update
Posted: 17 Apr 2012 10:00
by Pentris
Thank you Mike. That has worked a treat.