2022.2

l
field(): Always surrounds database field selections.
l
Record Set Number: The data page (or "record") of the data selection.
l
Child Number: Line Number in the record (if there are multiple lines returned for one single
record).
l
Field Name: The name of the field you want to retrieve.
l
Case Option: This can be one of three options:
l
KeepCase: Keeps the current uppercase and lowercase letters as they are.
l
UpperCase: Converts all letters to their uppercase equivalent.
l
LowerCase: Converts all letters to their lowercase equivalent.
l
Trim Option: Can either be "Trim" if you want to trim empty spaces before and after the data
selection or "NoTrim" if you want to retain the extra spaces.
Data Repository lookups
The Data Repository selections are made through the lookup function. Selections are done from the
data located in the "Data Repository Manager" on page707. The lookup function returns the value of a
single key, which is always a string. If the lookup operation fails to find any data, for any reason, the
return value is always "NODATA".
Syntax
lookup(group, return key, lookup key, lookup value)
Here is a breakdown of the syntax (all arguments are mandatory):
l
group: The name of the group in which to retrieve the value. Does not need to be surrounded by
quotes.
l
return key: The name of the key where the information you want to retrieve is located. Does not
need to be surrounded by quotes.
l
lookup key: The name of the key in the group with which to look up the value. The return key of
the KeySet in which the lookup key's value matches the lookup value will be returned.
l
lookup value: A string surrounded by quotes which will be used in the lookup.
The lookup syntax is akin to a SQL SELECT statement and could be loosely translated to:
SELECT [return key] FROM [group] WHERE [lookup key] = [lookup value];
PDF data selections
These selections are used for PDF data files. The selection refers to a specific area of any given page
of the PDF by using precise region coordinates (in inches).
Page 51