Changing Application Listings within the Go To

Answer

The MAXMENU table builds the listing and order of the Go To. To change the order/what applications appears within the Go To – run the following query:

select * from MAXMENU
where MENUTYPE = 'MODULE' and visible = '1'
order by position, subposition

The result of this query will show how the Go To menu is built.

In the following example, the Conditional Expression Manager will be moved from the Administration module to the Platform Configuration module:



1) To change a position of a Go To reference, you need to specify the MODULEAPP (what listing the application will appear in), the POSITION (numeric reference to the grouping of the application) and a unique SUBPOSITION value (in what order and where the application reference will appear).

Run the following query to gather the needed information in regards to the Conditional Expression Manager reference:

select moduleapp, position, subposition, keyvalue from MAXMENU
where MODULEAPP = 'SETUP' and KEYVALUE = 'CONDEXPMGR'

The following will be the result:



Run the following query to gather the needed information in regards to the Platform Configuration 'layout':

select moduleapp, position, subposition, keyvalue from MAXMENU
where MODULEAPP = 'UTIL'
order by position, subposition

The following will be the result:



From the results above, the MODULEAPP needs to be referenced as 'UTIL' and the POSITION (group) needs to be '11130' and the SUBPOSITION needs to be a unique value and based off the order of where the application will appear.

2) Run the following UPDATE statement to move the Conditional Expression Manager from the Administration module to the Platform Configuration application, in the very 1^st position:

UPDATE MAXMENU
set MODULEAPP = 'UTIL'
where keyvalue = 'CONDEXPMGR'

UPDATE MAXMENU
set POSITION = '11130'
where keyvalue = 'CONDEXPMGR' and MODULEAPP = 'UTIL'

UPDATE MAXMENU
set SUBPOSITION = '9'
where keyvalue = 'CONDEXPMGR' and MODULEAPP = 'UTIL'

commit;

Run the following select statement to see the results:

select moduleapp, position, subposition, keyvalue from MAXMENU
where MODULEAPP = 'UTIL'
order by position, subposition



Restart the Application Server

3) Log In to Maximo – Navigate to the System Configuration – Platform Configuration: