* Query for source certainty assessment

[MB@RE]

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

[tatewise]

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 fhugdownloads:contents:citation_details|> 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.

[MB@RE]

Mike, Thanks for your help, this does the job nicely.