Deleting an Application in Maximo

As a developer in Maximo, you end up either creating a new app (in app designer) to test something, or cloning existing apps. However, you probably noticed that there isn’t an option to delete an application. As it turns out, to delete an application in Maixmo, you have do to it from the database. Here is how.

What you will need:

·         Name of the application. This must be an all caps. In the code below, replace {MYAPP} with the name of your application.

·         Name of the module you placed your app under. In the code below, replace {MODULENAME} with the name of the module you used.

·         A tool for running SQL statements against the database.

·         DELETE rights to the following tables in the Maximo schema/database:

o    MAXAPPS

o    MAXPRESENTATION

o    SIGOPTION

o    APPLICATIONAUTH

o    MAXLABELS

o    MAXMENU

o    APPDOCTYPE

you want to delete is Test, replace APPLICATION NAME with TEST in all the

commands.

a. delete from maxapps where app=’<APPLICATION NAME>’;

b. delete from maxpresentation where app=’<APPLICATION NAME>’;

c. delete from sigoption where app=’<APPLICATION NAME>’;

d. delete from applicationauth where app=’<APPLICATION NAME>’;

e. delete from maxlabels where app=’<APPLICATION NAME>’;

f. delete from maxmenu where app=’<APPLICATION NAME>’ and menutype

!=’MODULE’;

g. delete from maxmenu where where elementtype=’APP’ and

keyvalue=’<APPLICATION NAME>’;

12 Developing Applications

h. delete from appdoctype where app=’<APPLICATION NAME>’;

i. delete from sigoptflag where app=’<APPLICATION NAME>’;

3. Logout of the database editor.