A lof of changes, like this, cannot be made via application but via SQL.. damn you IBM.
1. Create a new Test Module
INSERT INTO maxmodules (MODULE,DESCRIPTION,MAXMODULESID)VALUES('TEST','Test Module',(SELECT NVL(MAX (M.maxmodulesid),0)+1 FROM MAXMODULES M ))2. Create menus for Test module
The module has been created and now we need to put it into the correct position. Value of moduleapp is same as module from maxmodules.
INSERT INTO MAXMENU(MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
VALUES('MODULE','TEST',9500,0,'MODULE','TEST',NULL,NULL,1,'modimg_wo.gif',NULL,NULL,MAXMENUSEQ.NEXTVAL)btw: you must insert application into this module because empty module is not shown.
3. Attaching an application to the Test Module:
INSERT INTO MAXMENU(MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
VALUES('MODULE','TEST',9510,0,'APP','WOTRACK',NULL,NULL,1,'appimg_wotrack.gif',NULL,NULL,MAXMENUSEQ.NEXVAL)Functional example
Adding a newapplication View Incident in a new Incident Sub Module under Self Service Module.
Self Service ==> Incidents ==> View Incidents
INSERT INTO MAXMENU( (MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE, IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
values ('MODULE','SSDR',3230,0,'HEADER',null,'Incidents',NULL,1,'modimg_wo.gif', NULL,NULL,MAXMENUSEQ.NEXTVAL);
INSERT INTO MAXMENU((MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
values ('MODULE','SSDR3',3230,10,'APP','VWINC',null,NULL,1,'modimg_wo.gif', NULL,NULL,MAXMENUSEQ.NEXTVAL);