How to find Gen Windows which have customizations

Products

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

Issue/Introduction

As a result of having 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 customizations have been done.

Environment

Release: Any

Resolution

To find Primary Windows which have customizations 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

GUI Design > Navigation Diagram Overview > Common Edit Modifications and Remove Customization
NOTE: "Edit/Remove Customization":
a. Is only enabled when a control customization has been executed in HTML or ASP.Net modes (not Window mode)
b. Cannot be used to remove customizations for menu items.