ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to find CA Gen Windows which have customisations

book

Article ID: 127162

calendar_today

Updated On:

Products

Gen Gen - Workstation Toolset Gen - Host Encyclopedia Gen - Run Time Distributed

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.

Additional Information

"Common Edit Modifications and Remove Customization": https://docops.ca.com/ca-gen/8-6/en/developing/designing/using-toolset/understanding-toolset-diagrams/design-diagrams/gui-design/navigation-diagram-overview/common-edit-modifications-and-remove-customization
NOTE: "Edit/Remove Customization":
a. Is only enabled when a control customisation has been executed in HTML or ASP.Net modes (not Window mode)
b. Cannot be used to remove customisations for menu items.