Add Custom Modules to Go To Menu | Maximo

1. get max(MAXMODULESID) and add 20

select max(MAXMODULESID)+20 from maxmodules ; --42+20

now INSERT in MAXMODULES using the value from step 1.

Insert into MAXMODULES ( MODULE, DESCRIPTION, MAXMODULESID) values ('QMS', 'Quality Management System', 62)

2. get max(MAXMENUID) and add 200

select max(MAXMENUID)+200 from maxmenu; --18779+200

3. get max(POSITION) and add 1000

select max(POSITION)+1000 from maxmenu; --96033+1000

4. now INSERT in MAXMENU using the values from step 2 and 3.

Insert into MAXMENU (MENUTYPE, MODULEAPP, POSITION, SUBPOSITION, ELEMENTTYPE, KEYVALUE, HEADERDESCRIPTION, VISIBLE, IMAGE, MAXMENUID)

values ('MODULE', 'QMS', '97033', 0,'MODULE', 'QMS', 'Quality Management System', 1,'atb_bookmark.gif', 18979)