A.2.2 Version Dropdown Combination

The VERSION_DROPDOWN combination defines the configuration for the version selection drop down within the template.

• Combination Code: VERSION_DROPDOWN
• Component Type: COMP_SINGLE_SELECT_DROPDOWN

The following properties are configured:

INSERT INTO AF_TB_COMBINATION_MAPPING_DETAIL
VALUES ('COMP_SINGLE_SELECT_DROPDOWN','VERSION_DROPDOWN','PROP_REQUIRED','N');

INSERT INTO AF_TB_COMBINATION_MAPPING_DETAIL
VALUES (
  'COMP_SINGLE_SELECT_DROPDOWN',
  'VERSION_DROPDOWN',
  'PROP_DEPENDENT_SQL',
  '"SELECT AAICL_OBJECT_B.N_VERSION AS ""label"",
          AAICL_OBJECT_B.N_VERSION AS ""value""
     FROM AAICL_OBJECT_B
    WHERE AAICL_OBJECT_B.V_OBJ_CODE = {{queryProject}}"'
);

INSERT INTO AF_TB_COMBINATION_MAPPING_DETAIL
VALUES ('COMP_SINGLE_SELECT_DROPDOWN','VERSION_DROPDOWN','PROP_FINAL_JSON_KEY','version');