Map Combinations to Groups

A.3 Map Combinations to Groups

After defining the combinations, they must be organized into logical groups to control layout structure and component ordering within the template. This grouping is configured in the AF_TB_COMBINATION_GROUP_MAPPING table.

Two groups are created:

GROUP_CARTESIAN_TABLE
GROUP_DROPDOWN

The mappings are defined as follows:

INSERT INTO AF_TB_COMBINATION_GROUP_MAPPING
(V_GROUP_CODE, V_COMBINATION_CODE, N_COMPONENT_ORDER, F_SUMMARY_CHECK)
VALUES ('GROUP_CARTESIAN_TABLE','CARTESIAN_TABLE',1,'N');

INSERT INTO AF_TB_COMBINATION_GROUP_MAPPING
VALUES ('GROUP_DROPDOWN','SQL_PROJECT_DROPDOWN',1,'Y');

INSERT INTO AF_TB_COMBINATION_GROUP_MAPPING
VALUES ('GROUP_DROPDOWN','VERSION_DROPDOWN',2,'N');

These mappings determine:

Which combinations belong to each group
The display order of components within the group
Whether summary behavior is enabled for specific components