A.2.3 Project Dropdown Combination

The SQL_PROJECT_DROPDOWN combination defines the configuration for the project selection drop down within the template.

• Combination Code: SQL_PROJECT_DROPDOWN
• Component Type: COMP_SINGLE_SELECT_DROPDOWN

The following properties are configured:

INSERT INTO AF_TB_COMBINATION_MAPPING_DETAIL
VALUES (
  'COMP_SINGLE_SELECT_DROPDOWN',
  'SQL_PROJECT_DROPDOWN',
  'PROP_FINAL_JSON_KEY',
  '"SELECT DISTINCT
        s.V_OBJ_NAME AS ""label"",
        v.V_OBJ_CODE AS ""value""
     FROM AAICL_OBJECT_B v
     LEFT JOIN AAICL_OBJECT_TL s
       ON v.V_OBJ_ID = s.V_OBJ_ID
    WHERE v.V_OBJ_TYPE_CODE = ''EST_PROJECT''"'
);

INSERT INTO AF_TB_COMBINATION_MAPPING_DETAIL
VALUES ('COMP_SINGLE_SELECT_DROPDOWN','SQL_PROJECT_DROPDOWN','PROP_SQL','queryProject');