Introduction
In a QueryQuerying is a very powerful feature that allows you to specify and save criteria for identifying a set of records of a given record type. Column or Records WindowThe Records Window provides a comprehensive view of all the information stored within a Family Historian project. Column any long text such as Note fields and Text From SourceBoth Source records and Citations have a Text From Source field intended to hold transcripts of source documents. fields are truncated at about 150 characters with an ellipsis …
This workaround will display the full text.
Details
In the Column ExpressionExpressions are composed from two technical features: Data References and Functions; they also often involve Operators to compare values. use the =GetParagraph(%INDI.NOTE2%,1)
function, because it does NOT truncate the text.
To allow for the possibility of multiple paragraphs, several such functionsA 'function' is an expression which returns values based on computations. Typically, functions require data to be supplied to them as 'parameters'. A function in Family Historian is similar to a 'function' as used in spreadsheet applications (such as MS can be joined together:
=Text( GetParagraph(%INDI.NOTE2%,1) . " " . GetParagraph(%INDI.NOTE2%,2) . " " . GetParagraph(%INDI.NOTE2%,3) )
Just substitute whatever Data Reference is needed for the long text field required.
This technique also works in Diagrams and Reports but is rarely needed because long text fields are usually displayed in full.
The =GetLabelledText(%INDI.NOTE2%,"Label")
function also does NOT truncate long text.