MAXIMO 应用程序开发

Custom Application with Application DesignerCreate the Table Domain1.Create a table domain to the Asset table. This will be used to lookup the values inthe asset application. Call the Table Domain CUSASSET.2.Set the where clause assetnum=:assetnum and set the Organization = EAGLENAand the site = BEDFORD. This will restrict the domain to the specific site and organization.3.Click OK.4.Now that the domain is created we need to create the table that will store ourknowledge base data. So go the Database Configuration Application and create a new object titled KNOWAPP, set the application to the Organization level. Add the following columns, note maximo adds the key and long description fields.5.Create an index on the primary key KNOWAPPID.6.Create the following relationships KNOWASSET which will be used to lookupadditional columns in the Asset table and DRILLDOWN which enables us to use the drilldown for Assets and Locations.7.Save the object.8.Stop your Maximo server (Service), NOTE: It must be stopped before runningconfigdb.9.After configuring the database login to Maximo and open the ApplicationDesigner.10.Create a New Power Application associated to the Workorder Module referencingthe Application name KNOWAPP (this is the name you want to call theapplication. The description field of the application, the Main Object is the table name that you created earlier, and the Module Name is WO, i.e. where you want the application to be access from.. There are three types of applications that you can create: a power application such as Workorders, a simple power application such as the Chart of Accounts, and a self service application such as ServiceRequest or Desktop Requisitions.11.Save your application, note you Tab names will change to List and Main. Theapplication designer will display with an application shell, i.e., the presentation layer.12.The presentation layer is an XML schema to view the XML tags go to the selectaction and select the [Toggle Show All Controls] action. This will display the XML tags that are used display any of the screens in Maximo and cannot bechanged.13.Keeping with the standard naming conventions name the second tab KnowledgeBase to reflect the application by clicking on the white space next to the Main title and select the Control Properties icon. Change the properties of the tab to:14.Your screen should now appear as below:15.Now we need to design our screen by placing the a number of sections on theknowledge base tab. You want to add one more section than is required just in case you need to add a section at the bottom of the screen. Maximo will not allow to add a section at the bottom of the page but you can add in sections between other sections. Our design will need five sections. So open the controls palette and select the section control. Draw the control unto the white space under the tab title and release your mouse.16.Repeat the process five times. Your screen should now appear as below.17.Select the top section and open the control properties and change the labelproperty to ‘Section 1’. Your screen should now appear as below.18.Change the remaining label to read section 2- 5. Your screen should appear asbelow.19.Now that we have our sections defined we will need to add in section rows whichwill enable us to further add section columns that will in turn enable us to add section columns, then sections within those columns. So in section 1 add a section row.20.Add a new section in the section row you just created.21.Repeat the process for section 2 using the same controls.22.In section three add a section row, section column, and place a new section ineach column.23.In section four accomplish the same process except add in two section columns.24.Section 5 is a dummy section and will be deleted so make no entries here.25.Save.26.Now we are ready to add our controls and relate those to our database columns.Here is the list of database columns and respective controls that we will use.27.Control PropertiesError in the screen below. Deals with a relationship see if you can solve.28.The next steps is to add in security options, actions, place icons, and modify thesearch page.Result: a drop down list of actions that can be applied to an application.Click on Add/Modify Signature OptionsResult: the Add/Modify Signature Options dialog will open.Result: a data entry screen will display.Click on New Row.Result: a data entry screen will open.Click on New RowRemember to authorize the choices though the Security Groups.1.Changing default field size.In order to change the default size of fields you need to modify this file. Back up before you make any changes.Open the file and locate the field type that you want to change the display size of and follow the following example.//For ALN, LOWER, UPPER field typesfieldtypegroup = new Hashtable();fieldtypegroup.put(new Integer("2"), new Integer("2"));fieldtypegroup.put(new Integer("30"), new Integer("10"));fieldtypegroup.put(new Integer("31"), new Integer("40"));fieldsizegroups.put(new Integer(FIELD_TYPE_ALN).toString(), fieldtypegroup);fieldsizegroups.put(new Integer(FIELD_TYPE_LOWER).toString(), fieldtypegroup);fieldsizegroups.put(new Integer(FIELD_TYPE_UPPER).toString(), fieldtypegroup);∙If the database field size is 1 or 2, then the screen size is 2.∙If the database field size is 3 through 30, then the screen size is 10.∙If the database field size is greater than 30, then the screen size is 40. This will apply to all field types ALN, UPPER and LOWER.Other field types are listed individually where these are grouped together.2.Creating a hyperlink to another application.Linking to another application can be done at least three different ways:1. hyperlink2. Pushbutton3. Or, add as a Go To property to a field in the Textbox properties dialog. The Go To field is not long enough to just add another look so you go to the xml and add the applink to the applicable field (see below).<tablecol id="po_tablebody_1" dataattribute="ponum" menutype="normal" applink="po,receipts" /> Note: this was done on viewdr.xml. On the PO number field on the History tab. Adding the hyperlink caused the Receving application to be launched for that PO.3.Adding a default value to an xml page rather than at the database level (note: used toset a default value in the Select Owner dialog box.Create a default value id tag within the table/dialog of where the field is located..Tag:<defaultvalue id="owner_labor_owner_labordiv1_1_1_tbllabor_default_1" dataattribute="department"value="IT" defaulttype="query" />Table:Note: this was done to default a value in the Department field in the Select Owner dialog.4. Commenting out a section on the xml.This is an example of commenting out an entire section with only two sections on the page. If there is only one section, then the method is to comment out the row which is not needed for a single section. To comment it out do not change existing line details add<!—or --> where applicable. Note: when commenting out a section there can not be any comments within that section, so if a row has been commented out prior to the section then you have to remove it before the section can be commented out.Result:Before changeAfter change:Note that the remaining section now spans the entire page and the fields are centered.5.adding an ALN DOMAIN.In app designer highlight the field that the domain is attached (in db config), click on the properties icon, and enter ‘Valuelist’ in the LOOKUP field.The domain field should have the name of the ALN Domain created. The example below includes a default value of ACTIVE.6.Adding a standard lookup to a new field with a condition. In app designer weindicate that the lookup is person we have to create a Table Domain. Here wedisplay the person lookup for person’s in the ACTIVE status. This lookup wasadded to look up a Supervisor if the Personid in the Supervisor field waswrong.DomainApplication DesignerDatabase Configuration29.。