效果:
1 LOV的创建及参数传递
Record group query:
LOV column mapping:
LOV中每个column的值跟据mapping赋值给block中相应的item
2 Query_Find中参数传递
通过trigger PRE_QUERY中的COPY将query_find
Block 中的item的值传递给result block中相应的item
--:IF :parameter.G_query_find = TRUE THEN
-- COPY (<find Window field>,<results field>);
-- :parameter.G_query_find := FALSE;
--END IF;
IF :parameter.G_query_find = 'TRUE' THEN
COPY(:QUERY_FIND.EMPNO, 'XX425457_EMPLOYEES.EMPNO');
COPY(:QUERY_FIND.FIRST_NAME, 'XX425457_EMPLOYEES.FIRST_NAME');
COPY(:QUERY_FIND.LAST_NAME, 'XX425457_EMPLOYEES.LAST_NAME');
:parameter.G_query_find := 'FALSE';
END IF;
--APP_STANDARD.EVENT('QUERY_FIND');
--APP_FIND.QUERY_FIND(<results block window>,<Find window>,<Find window block>);
APP_FIND.QUERY_FIND('XX425457_EMPLOYEES', 'QUERY_FIND','QUERY_FIND');
3 Template中标准Calendar的使用
Item Date_Joined 的LOV选择Template中定义好的LOV TIMEZONES_AND_DATETIME
Validate from List 选择NO
Date fields should use the ENABLE_LIST_LAMP LOV, which is included in the TEMPLATE form. This setting enables the menu and Toolbar List of Values entries for your date fields. Set '"Validate from List" to No on fields that use this LOV. If you leave "Validate from List" set to Yes, you will see an LOV that has no columns.
创建 Trigger Key-LISTVAL: CALENDAR.SHOW