* Query for source certainty assessment

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
MB@RE
Platinum
Posts: 35
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Query for source certainty assessment

Post by MB@RE » 11 Dec 2019 13:17

Hi,

I'm looking for a simple query which shows the source certainty assessment note field for each fact.
Would someone please point me in the right direction whether it's a source query, fact query, individual query; along with the query label.

Thanks.

Mike
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

User avatar
tatewise
Megastar
Posts: 17066
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query for source certainty assessment

Post by tatewise » 11 Dec 2019 13:51

Yes, that is a bit trickier that it sounds, because it is not each Fact that has the Assessment, but each Citation, which are mostly attached to Facts but also to Individual or Family records as a whole, and other types of data too.
There are various possible solutions depending on exactly what you want.

Where Used Records Links Plugin
In the Records Window on the Sources tab select every Source record.
Run the Plugin and the Result Set will list every Citation giving the Field Where Used and the Assessment along with all the other Citation details.

Fact Query
This will only list Citations linked to Facts and none of the other possibilities listed by the Plugin above.
See Knowledge Base > Query:Fact ~ Citation Details downloads.
They only show the 1st, or 2nd, or 3rd Citation on each Fact, but since you only want the Assessment you could remove most of the Columns and just have the following:
Source Link 1 ~ %FACT.SOUR[1]>%
Assessment 1 ~ %FACT.SOUR[1].QUAY%
Source Link 2 ~ %FACT.SOUR[2]>%
Assessment 2 ~ %FACT.SOUR[2].QUAY%
Source Link 3 ~ %FACT.SOUR[3]>%
Assessment 3 ~ %FACT.SOUR[3].QUAY%
and so on, depending how many Citations any one Fact has.
On the Rows tab use Add if %FACT.SOUR[1]>% exists.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
MB@RE
Platinum
Posts: 35
Joined: 14 Sep 2013 11:04
Family Historian: V6
Location: Warwickshire

Re: Query for source certainty assessment

Post by MB@RE » 11 Dec 2019 14:11

Mike, Thanks for your help, this does the job nicely. :D
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

Post Reply