Lubos Strejcek
Oct 20, 2017
Updated: Dec 6, 2022
A lof of changes, like this, cannot be made via application but via SQL.. damn you IBM.
INSERT INTO maxmodules (MODULE,DESCRIPTION,MAXMODULESID)VALUES('TEST','Test Module',(SELECT NVL(MAX (M.maxmodulesid),0)+1 FROM MAXMODULES M ))
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.
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)
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);