* Query update

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

Query update

Post by Pentris » 16 Apr 2012 16:07

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

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

Query update

Post by tatewise » 16 Apr 2012 20:54

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

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

Query update

Post by Pentris » 17 Apr 2012 10:00

Thank you Mike. That has worked a treat.

Post Reply