Update List (XF110)
The type for functions to update records in the primary table. When executed,
Select-List is shown where the user select rows to be updated (you can put criteria
to filter rows to be listed). By pushing
Next button, selected rows are listed in update mode. If you define
Batch-Table, new records will be inserted into the table according to
Batch-Condition when rows are updated.
Form sample of Update List
Editting the definition of the function above
Elements to be defined
<
Basic Attributes>
Function Type - Fixed value.
Function ID - Fixed and unique value in the system.
Function Name - Editable value to express function role applied as the title on the
panel.
Primary Table - The main table which records to be listed. Possible to define alternative key to be processed.
Order By - Order of rows listed. Possible to put fields on the join tables as well
as ones on the primary table.
Fixed Where - Fixed where criteria integrated into SELECT statement. It has to be
for fields on the primary table. You can use User/Session attributes as
variants(*1).
When Row Selected - The action when a specific row is selected and enter-typed. If Calling
is selected, the function to be called must be specified.
Exchanging - The type of parameters(HashMap) when row selected. If KEYS selected,
values of key fields are returned. If COLUMNS selected, values of all columns
will be returned with datasource name(field ID with table alias).
Panel Size - Select one of options.
Scanning By - Block size of selecting process (note that it's not listing size). Default
is '*All'. If specified, a dialog is shown to ask if keeping on scanning
or not.
List when launched - If checked, rows are listed when the panel shown. With no criteria defined, rows are always listed when launched.
Execute Msg. - Message shown in the panel with
Confirm-List.
*1.Specify like USER_ATTRIBUTE:type for
User Attribute(*3). Specify like SESSION_ATTRIBUTE:id for
Session Attbirute(*4). If comparing string values, use single quotation as follows.
DTTHRU >= 'SESSION_ATTRIBUTE:DateFrom' AND DTTHRU <= 'SESSION_ATTRIBUTE:DateThru'
<
Columns>
Definitions of columns to be listed which are fields on the primary table or join tables. When executed by Driver, those fields on join tables or external key of
batch table will be listed as non editable. Right-click the list on Editor to add/delete columns. Drag the row of column to change order of columns. Select the row to edit attributes of the definition as follow.
Table - Table ID and name which owns the field (Non editable)
Type - Table type of the table (Non editable)
Field - Field ID and name (Non editable)
Type - Data type, length and ext-type of the field (Non editable)
Layout Option - If
Vertical selected, it will be layouted on the next row. If
Horizontal selected, it will be layouted right side of the previous column. If
Hidden selected, it will not shown on the row.
Width - Width of the column in pixcels. If
*Auto specified, Driver will adjust size according to the caption or data size.
Rows - Height of the column in rows. If
*Auto specified, image field is set as 2 rows and else as 1 row.
Caption - Column heading. Select
Column Name or
Value. By using SESSION_ATTRIBUTE:id, you can control column heading dinamically
(Note that you can not check design of the panel on Editor then).
Prompt - Setting of the column in update mode.
None represents direct input.
List Box is to edit with list box. Call ID is to edit by calling function.
<
Filters>
Criteria to filter rows to be listed. If none specified, all records are
listed. The function will scan filter value in parameters(HashMap) with
datasource name and if found the value is processed as the filter. Right-click
on the list to add/delete criteria. Drag the row of criteria to change
their order. Note that if multiple criteria defined they work as
AND conditions(*2). Select the row to edit attributes of the definition as
follow.
Table - Table ID and name which owns the field (Non editable)
Type - Table type of the table (Non editable)
Field - Field ID and name (Non editable)
Type - Data type, length and ext-type of the field (Non editable)
Layout Option - If
Vertical selected, it will be layouted on the next row. If
Horizontal selected, it will be layouted right side of the previous column.
Width - Width of the column in pixcels. If
*Auto specified, Driver will adjust size according to the caption or data size.
Margin - Margin to left side field.
Edit Option - If
Editable selected, it will be set editable. If
Non Editable selected, set non editable. If
Hidden selected, set to be hidden. Value of hidden filter should be passed as
a parameter by calling functions.
Filter Option - Option of scanning. Select one of those following.
EQ Select the record if values match.
SCAN Select the record if field value contains filter value.
GENERIC Select the record if field value starts with filter value.
LE Select the record if field value *LE filter value. Only for numeric field.
LT Select the record if field value *LT filter value. Only for numeric field.
GE Select the record if field value *GE filter value. Only for numeric field.
GT Select the record if field value *GT filter value. Only for numeric field.
REFLECT Filter value will be set to the field. Only for virtual field.
Caption - Label of the filter field. Select
Field Name or
Value. By using SESSION_ATTRIBUTE:id, you can control column heading dinamically
(Note that you can not check design of the panel on Editor then).
Initial Value - Specify in one of those formats following.
VALUE:value Specified value(without literals) is set as initial value. "VALUE:"
is omittable.
USER_ATTRIBUTE:type Value of User Attribute(*3) registered with the type is set as initial value.
SESSION_ATTRIBUTE:id Value fo Session Attribute(*4) with the id is set as initial value.
Prompt - If
None selected, value is input directly. If
Generic List selected, value list will be given according to typed characters. If
Optional List or
Required List selected, values will be listed.(Difference is whether selecting is required or not). If
Call ID is selected, the button to launch specified function will be given.
*2.If some criteria are defined for a specific field, they work as
OR conditions.
*3.The type can be either of ID, EmployeeNo, Name. For example if you want
to get user ID, define as USER_ATTRIBUTE:ID.
*4.Session attributes can be registered using scripts (typically using
Login Script). If specified attribute with id is not found, Driver will show an error
message. For example if you want to get value of session attribute registered
with id of "Today", define as SESSION_ATTRIBUTE:Today.
<
Batch Table>
The function can insert one or some records into the
batch table when records on the primary table updated. Set configurations as follow.
Batch Table - It has to be a join-table of the primary table. Select one of them listed
in the list box. Those records with identical values of '
batch key' field(s) are counted as a '
batch'. Records will be inserted into the
batch table one by one batch. Specify
batch key of the primary table with datasource name and without for the batch table.
Use ';' to separate fields.
Batch Function - If specified, the function will be executed on records inserted.
Check to Run - Specify the message to check if the batch function is to be executed
or not.
Batch Field List - Fields of the batch table(and its join tables) which are shown on header
area of the function. Right-click on the list to add/delete fields. Drag
the row of field to change their order. Select the row to edit attributes
of the definition as follow.
Table and Type Table ID, name and its type
Field and Type Field ID, name and its type
Layout Option If Vertical selected, it will be layouted on the next row. If Horizontal selected, it will be layouted right side of the previous column.
Width/Rows/Margin Specify values in pixcels for width and margin.
Caption/Width Auto-Adjusted Specify values as required. You can also use SESSION_ATTRIBUTE:id for
the caption.
Prompt Style of prompter. Select either of None, ListBox, Call(with function id
and values exchanging).
Comment If specified, the value appears on the right side of the field.
<
Function Keys>
Definitions of function keys at the bottom of the panel. Right-click on
the list to add/delete definitions. Max of definitions is 7. Select the
row to edit attributes of the definition as follow.
Position - Position of the button. 0 represents left end and 6 right end.
Function Key No - Function key number(F1-F12) allocated to the button.
Caption - Caption of the button.
Action - Action allocated to the button. Values selectable are "Exit",
"Back to Select-List", "Go to Update-List", "Update"
and "Output into EXCEL".
<
Where-Used>
The list of functions using this function. Right-click on the row to jump
to the definition.