Enable PPM fields in OpenText Application Quality Management defects or requirements

By default, the PPM-related fields for the integration are not enabled to be shown in OpenText Application Quality Management project requirement or defect details page. See Enable fields in OpenText Application Quality Management entities for details of these fields.

Do the following to make these fields visible in OpenText Application Quality Management.

• For a non-version controlled OpenText Application Quality Management project:

  • To enable PPM fields in OpenText Application Quality Management defects, run the following SQL in the Site Administration:

    update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME ='BUG' and SF_COLUMN_NAME like 'BG_REQUEST%'

  • To enable PPM fields in OpenText Application Quality Management requirements, run the following SQL in the Site Administration:

    update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME = 'REQ' and SF_COLUMN_NAME like 'RQ_REQUEST%'

• For a version controlled OpenText Application Quality Management project:

  • To enable PPM fields in OpenText Application Quality Management defects, run the following SQL in the Site Administration:

    update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME ='BUG' and SF_COLUMN_NAME like 'BG_REQUEST%'

  • To enable PPM fields in OpenText Application Quality Management requirements, run the following SQL in the Site Administration:

    update <db_name>.SYSTEM_FIELD set sf_is_active = 'Y', SF_IS_VISIBLE_IN_NEW_BUG='11111', sf_is_system = 'N', sf_udf_version=1, sf_can_change_permissions='Y', sf_grant_modify='11100' where sf_table_name = 'REQ' and SF_COLUMN_NAME like 'RQ_REQUEST%'