* Citation Specific Details in Queries
-
- Gold
- Posts: 19
- Joined: 12 Dec 2023 15:23
- Family Historian: V7
Citation Specific Details in Queries
I'm trying to list a the "Citation Detail" field in a query and can't figure out the expression. There are four citation specific fields in the citation:
Citation Detail
Reference
Assessment
Note
Assessment is %FACT.SOUR[1].QUAY% and Note is %FACT.SOUR[1].NOTE2[1]%
But I can't figure out the expressions for Citation Detail or Reference. Is there a list of data expressions anywhere?
Citation Detail
Reference
Assessment
Note
Assessment is %FACT.SOUR[1].QUAY% and Note is %FACT.SOUR[1].NOTE2[1]%
But I can't figure out the expressions for Citation Detail or Reference. Is there a list of data expressions anywhere?
- ColeValleyGirl
- Megastar
- Posts: 5520
- Joined: 28 Dec 2005 22:02
- Family Historian: V7
- Location: Cirencester, Gloucestershire
- Contact:
Re: Citation Specific Details in Queries
The best place to look is the Query Window, creating a new query (which you don't need to save )
Helen Wright
ColeValleyGirl's family history
ColeValleyGirl's family history
-
- Gold
- Posts: 19
- Joined: 12 Dec 2023 15:23
- Family Historian: V7
Re: Citation Specific Details in Queries
ColeValleyGirl I'm not sure what you mean. I've been in the Query window and looked through the "Data Reference Assistant" but still can't find the field. I haven't been able to find any standard queries that have the field. The footnote in the source template does include it as the field <{Citation_Detail}> but that doesn't work in a query.
- tatewise
- Megastar
- Posts: 28488
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Citation Specific Details in Queries
Unfortunately, the Query > Columns tab > Fields pane does not support Templated Named Metafields.
Please refer to the Help for Understanding Data References and scroll down to Data References And Metafields.
There it explains the data reference structure for metafields.
e.g.
%FACT.SOUR[1].~TX-REFERENCE% for a Text metafield named Reference.
Bear in mind that only returns the metafield for the 1st Citation and not the 2nd or 3rd Citation.
Please refer to the Help for Understanding Data References and scroll down to Data References And Metafields.
There it explains the data reference structure for metafields.
e.g.
%FACT.SOUR[1].~TX-REFERENCE% for a Text metafield named Reference.
Bear in mind that only returns the metafield for the 1st Citation and not the 2nd or 3rd Citation.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- ColeValleyGirl
- Megastar
- Posts: 5520
- Joined: 28 Dec 2005 22:02
- Family Historian: V7
- Location: Cirencester, Gloucestershire
- Contact:
Re: Citation Specific Details in Queries
Apologies -- I didn't realise ypu were referring to Templated Sources.
Helen Wright
ColeValleyGirl's family history
ColeValleyGirl's family history
- tatewise
- Megastar
- Posts: 28488
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Citation Specific Details in Queries
They had to be Templated Sources because Citation Detail and Reference are not Generic fields.
BTW: Once you create a Query it is immediately saved. You would have to specifically delete it.
You can use any existing Query to interrogate the Fields DRA without affecting the Query.
BTW: Once you create a Query it is immediately saved. You would have to specifically delete it.
You can use any existing Query to interrogate the Fields DRA without affecting the Query.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- ColeValleyGirl
- Megastar
- Posts: 5520
- Joined: 28 Dec 2005 22:02
- Family Historian: V7
- Location: Cirencester, Gloucestershire
- Contact:
Re: Citation Specific Details in Queries
tatewise wrote: ↑18 Apr 2024 15:51 They had to be Templated Sources because Citation Detail and Reference are not Generic fields.
BTW: Once you create a Query it is immediately saved. You would have to specifically delete it.
You can use any existing Query to interrogate the Fields DRA without affecting the Query.
Clever clogs
Helen Wright
ColeValleyGirl's family history
ColeValleyGirl's family history
-
- Gold
- Posts: 19
- Joined: 12 Dec 2023 15:23
- Family Historian: V7
Re: Citation Specific Details in Queries
Thanks all,
After some trial and error, I was able to find %FACT.SOUR[1]._FIELD[1]% as the needed expression. Can I assume that %FACT.SOUR[2]._FIELD[1]% would be the same field in the 2nd source listed?
After some trial and error, I was able to find %FACT.SOUR[1]._FIELD[1]% as the needed expression. Can I assume that %FACT.SOUR[2]._FIELD[1]% would be the same field in the 2nd source listed?
- tatewise
- Megastar
- Posts: 28488
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Citation Specific Details in Queries
That will refer to whatever happens to be the 1st Templated metafield in each Citation.
To refer to them by name see the Help for Understanding Data References and scroll down to Data References And Metafields as I explained earlier.
To refer to them by name see the Help for Understanding Data References and scroll down to Data References And Metafields as I explained earlier.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry