How to find CA Gen Windows which have customisations
Article ID: 127162
Updated On:
Products
CA Gen
CA Gen - Build Tool
CA Gen - Workstation Toolset
CA Gen - Host Encyclopedia
CA Gen - Run Time Distributed
3RD 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.
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.
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.
Feedback
Yes
No
Powered by
