How to find CA Gen Windows which have customisations
book
Article ID: 127162
calendar_today
Updated On:
Products
CA GenCA Gen - Build ToolCA Gen - Workstation ToolsetCA Gen - Host EncyclopediaCA Gen - Run Time Distributed3RD PARTY TSO
Issue/Introduction
As a result of having CA Gen Toolset Window Navigation Diagram option "Common Edit Modifications" turned off /disabled during model edit activities Windows controls can become inadvertently changed in HTML and ASP.Net modes. Sometimes it is required to reset all modes to have the same layout as the main Window mode and therefore it would be useful to get a list of all Windows & Dialog Boxes where customisations have been done.
Environment
CA Gen, any version
Resolution
To find Primary Windows which have customisations the following SQL can be used:
Client Server Encyclopedia (CSE): select o1.obj_name, o1.obj_id from dmdl, dobj o1 where model_name = '<MODEL NAME>' and o1.obj_model_id = model_id and o1.obj_type_code = 295 and exists (select assoc_from_obj_id from dasc a1 where a1.assoc_from_obj_id = o1.obj_id and a1.assoc_type_code in (1118,1120));
Host Encyclopeda (HE): SELECT P1.PROP_CHAR_VAL FROM DMDL, DOBJ O1, DPRP P1 WHERE MODEL_NAME = '<MODEL NAME>' AND O1.OBJ_MODEL_ID = MODEL_ID AND O1.OBJ_TYPE_CODE = 295 AND O1.OBJ_ID=P1.PROP_OBJ_ID AND P1.PROP_TYPE_CODE=224 AND EXISTS (SELECT ASSOC_FROM_OBJ_ID FROM DASC A1 WHERE A1.ASSOC_FROM_OBJ_ID = O1.OBJ_ID AND A1.ASSOC_TYPE_CODE IN (1118,1120)) ORDER BY P1.PROP_CHAR_VAL;
In above: Object Type Code 295 = WINPRIME object (Primary Window) Association Type Code 1118 = CUSTMIZE association Association Type Code 1120 = HASCST association
Dialog Boxes (DLGBOX) can also be checked by using Object Type Code 249 in the above SQL instead of 295.