Here is an example of how to add the attachment capability to the organizations (MULTISITE) application.
Add the ‘attachment’ control to the MULTISITE application using the Application Designer.
Then add the DOCLINKS relationship to the ORGANIZATIONS object as shown in the following picture.
Please check the ‘Where Clause’ statement and modify it to match your application. The where clause must be: ownertable='[MAIN_APP_OBJECT]’ and ownerid=:[OBJECT_ID]
The [MAIN_APP_OBJECT] can be retrieved in the Application Designer and the [OBJECT_ID] can be determined through the ‘Indexes’ tab in the Database Configuration looking for the unique/internal index.
Note that this database change does not require to run dbconfig.
The last step is to insert a row in the APPDOCTYPE table to tell Maximo that the application MULTISITE supports attachments.
For DB2 use this INSERT statement:
INSERT INTO MAXIMO.APPDOCTYPE (APP, DOCTYPE, APPDOCTYPEID) VALUES ('MULTISITE', 'Attachments', (NEXT VALUE FOR MAXIMO.APPDOCTYPESEQ)); COMMIT;
For Oracle use this INSERT statement:
INSERT INTO MAXIMO.APPDOCTYPE (APP, DOCTYPE, APPDOCTYPEID) VALUES ('MULTISITE', 'Attachments', (MAXIMO.APPDOCTYPESEQ.NEXTVAL)); COMMIT;
You can check the table content with the following query:
SELECT * FROM MAXIMO.APPDOCTYPE WHERE APP='MULTISITE';
Now you should be able to attach documents and pictures to your organization.