* Citation Specific Details in Queries

[StephensKS]

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?

[ColeValleyGirl]

The best place to look is the Query Window, creating a new query (which you don't need to save )

[StephensKS]

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]

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.

[ColeValleyGirl]

ColeValleyGirl I'm not sure what you mean.

Apologies -- I didn't realise ypu were referring to Templated Sources.

[tatewise]

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.

[ColeValleyGirl]

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

[StephensKS]

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?

[tatewise]

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.