Dynamic generation of record groups and Lov

V_group_name Recordgroup;
V_add_gname Groupcolumn;
V_group_sql number;

1, defining SQL statements

V_sql: = SELECT Short_code, Description from dual

2, query the record group for existence by name

V_group_name:=find_group (Ca.result_column_name)

IF id_null (V_group_name) Then

--Not present

3, V_group_sql: = Populate_group_with_query (V_group_name, v_sql); --Reset SQL

4,set_lov_property (Ca.result_column_name, Group_name, v_group_name); --set Lov and record group relationship

5,set_lov_property (Ca.result_column_name, Lov_size, 3, 4); --Set Lov SIZE

6,set_item_property (' Cux_qa_report_lines. ' | | Ca.result_column_name, Lov_name, ca.result_column_name); --Set the relationship between item and Lov

Dynamic generation of record groups and Lov