Installation guide

Setting Description
Lookup editor This editor allows you to create and modify queries. The following can be set:
l Lookup result key:Enter the name of the data publishing key you want to
use for finding the results. This key will be the output of the lookup operation.
If left empty, and the rest of the dialog is filled, this field is populated
automatically, based on the values of different fields; it can be edited any
time if the dialog populates it automatically.
l Display label:Enter a label of the text field that is displayed on the MFP UI
for the specific field. If left blank, the field is populated automatically based
on the value of the Lookup result key field.
l Lookup type:allows you to select the type of lookup query to be used. The
available choices are Database lookup, Custom SQLquery, and
Expression.
By selecting Database lookup, you can use the simple user friendly editor to
set up the lookup criteria. With Custom SQL query, you can use complex
SQL queries (specified in a text editor window), while the Expression option
allows you to specify C# expressions, allowing full flexibility in comparison
and working logic.
l Lookup evaluation condition:When the always evaluated option is
selected, the lookup specified is always performed. If the other option is
selected, the specified condition is evaluated – a selected data publishing
key is checked if it is not blank, equal to a specified value, or matching a
regular expression; the lookup operation is performed only when the result is
true.
l Database:use the dropdown menu to select the database on which the
query will be run (referring to an item defined on the first tab).
l Data source: use the dropdown menu to select the database table to be
queried.
l Expression templates:use the dropdown menu to select specific C#
expression templates. When selected, you can click the pencil icon to copy
the expression into the editor window. Clicking the msdn button opens a
browser, and displays the expression-specific MSDN article (when you have
an active Internet connection).
l Filter: here, you can put together the filter methods used by the Database
lookup queries. Use the + and - icons to add or remove search criteria. In the
Source field(s) column, you can select a field (column) of the table of the
selected database to compare with the value specified in the Look up
values(s) column. By clicking the button with the ellipsis, you can specify a
(constant) value right here, or by clicking on the button with the down-pointing
arrow, you can select from the data publishing keys available. The second
column is the place where the comparison operation can be defined.
Rightmost column (Operator) comes into the picture when multiple lookup
criteria is used (that is, there are more than one rows in the Filter table), and
can have the AND or the OR value selected.
l Target field:use the dropdown menu to select which database field will be
used as the target criterion.
l Lookup behavior:use this dropdown menu to set the number of results the
query should consider. Select One value only if you are looking for a
specific database entry; otherwise, select Multiple values or not required.
When One value only is specified, and the result of the lookup was a single
value, the UI interaction is initiated (at the MFP). If the lookup was not
successful (value not found), the user has to enter a value into a text box at
the MFP. If there are multiple values returned by the lookup, the user is
prompted to select from the available values.
When the Multiple values or not required option is selected, and the result
of the lookup is a single value or no matching item is found, that single value
or an empty value is used. If there are multiple values in the result, all are
included in the result data publishing key, separated by a separator
character.
l Test: click this button to test your query.