HDR/DTL Inquiry (XF300)
The type for functions to show a record in the primary table and lists
of related records in detail tables. When executed, it will fetch the
header record and select related
detail records to show them on the form. With multiple detail tables specified, it shows the form with
tab controls to change views of selected records. You can specify the functions to
process
detail record as well as the
header record. Also you can specify
recursive table to show its records in tree view on the left side of the form.
Function sample of HDR/DTL Inquiry

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 - Descriptive expression of the function that is set as the form title.
HDR Table - The main table which record is shown on the form. Possible to define
alternative key to be handled.
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).
HDR Function - The function linked to the function key(button) processing the header
record. You can also specify additional parameters of fixed value like
INSTANCE_MODE:INQ. Use ; to separate parameters like PARM1:VALUE1;PARM2:VALUE2.
Panel Size - Select one of options.
*1.Specify like USER_ATTRIBUTE:type for
User Attribute(*2). Specify like SESSION_ATTRIBUTE:id for
Session Attbirute(*3). If comparing string values, use single quotation as follows.
DTTHRU >= 'SESSION_ATTRIBUTE:DateFrom' AND DTTHRU <= 'SESSION_ATTRIBUTE:DateThru'
*2.The type can be either of ID, EmployeeNo, Name. For example if you want
to get user ID, define as USER_ATTRIBUTE:ID.
*3.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.
<
HDR Fields>
Properties to handle fields on the HDR table or its join tables. Right-click
on the list to add/delete fields. Drag the row of field to change order.
Select the row to edit attributes 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 field.
Width - Width of the field in pixcels. If
*Auto specified, Driver will adjust size according to the caption or data size.
Rows - Height of the field in rows. If
*Auto specified, image field is set as 11 rows and VARCHAR field is set as 2
rows and else as 1 row.
Margin - Margin to the previous field.
Caption - Heading of the field. Select
Field Name or
None or
Value. By specifying SESSION_ATTRIBUTE:id as
Value, you can control value of heading dinamically (Note that you can not check
design of the panel on Editor then). By checking
Width Auto-Adjusted, caption width will be adjusted automatically.
Prompt - Setting of the field in edit mode.
None represents direct input.
List Box is to edit with list box. Call ID is to edit by calling function.
Comment - If specified, the value appears on the right side of the field.
<
DTL Tabs>
Properties of the tab control which is allocated to a specific DTL table.
Records of the DTL table are listed in tab controls(max 20) with respectable
set of function keys. You can dinamically set each tab control enabled/disabled
using a parameter of 'DISABLED_TAB_LIST'(Indexes of tab controls to be
disabled separated by comma. Index of the first tab is 0). Drag the row
of tab control to change order. Select the row to edit attributes as follow.
Caption - Descriptive name shown on the tab control
Initial Message - Message shown in message area when the tab selected
DTL Table - The table which records to be listed. It has to be
Child or
Refered table of HDR table.
Order By - Order of rows listed. Possible to put fields on the join tables as well
as ones on the HDR 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.
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). You can
also specify additional parameters of fixed value like INSTANCE_MODE:INQ.
Use ; to separate parameters like PARM1:VALUE1;PARM2:VALUE2.
List when launched - If checked, rows are listed when the panel shown.
<
DTL Tabs -
Columns>
Definitions of columns to be listed in the tab control which are fields
on the DTL table or join tables. Right-click on the list 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).
<
DTL Tabs -
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(*4). 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(*2) registered with the type is set as initial value.
SESSION_ATTRIBUTE:id Value fo Session Attribute(*3) 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.
*4.If some criteria are defined for a specific field, they work as
OR conditions.
<
DTL Tabs -
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",
"Call DTL function to add", "Output into Excel", "Calling",
"Return selected rows" and "Return null key".
Function ID - Specify id of the function called if Action is set as "Calling".
Keys of the header record will be exchanged. You can also specify additional
parameters of fixed value like INSTANCE_MODE:INQ. Use ; to separate parameters
like PARM1:VALUE1;PARM2:VALUE2.
<
Structure Tree>
Settings of the tree view pane. Typically BOM(bill of materials) is defined
here and user can explode/implode stuructures to show them in tree vies.
Structure Table - Recursive table related to the header table. Specify table ID and processing
key configurations.
Root Text - Format of the root node expression. You can put ID of physical fields(in header table) and fixed string value in it.
Node Text - Format of the child node expression. You can put datasouece name of
physical fields(in header table or structure table) and fixed string value
in it.
Node Icon - Setting of icon of each node. You can specify hoices of icon image files
which is allocated according to the value of a specific field in the header
table.
Tree View Width - Width of tree view pane valid from 50 to 500
Tree View Caption - The title of tree view pane. If left blank, the structure table name
is set.
<
Where-Used>
The list of functions using this function. Right-click on the row to jump
to the definition.