Simplified Procedure to Generate Maximo Logs | IBM Maximo

Logger = sql
Log Level = INFO
Appenders = Console,Rolling

Logger = application
Log Level = DEBUG
Appenders = Console,Rolling

Hit Save button
 
Select Action > Apply Settings
Done :)

Reference:

Send an email to the person in the reportedby field of a ticket? | IBM Maximo

 Is it possible to send an email to the person in the reportedby field of a ticket?

Answer

Steps:
1. Go to Roles application.
2. Create a new role called REPORTEDBY under Administration module > Workflow.

ref: http://www-01.ibm.com/support/docview.wss?uid=swg21497185

Which ROS (Parent Categories) can security groups access for their individual report creation? | IBM Maximo

Application: Report Administration
Action: Set Report Object Structure Security
Applies To: Ad Hoc (QBR) Reports Only

Sorting data of the relationship attributes | IBM Maximo

Sorting:

You cannot sort data of the relationship attributes or non-persistent attributes.

Filtering:

you can filter relationship attribute but not non-persistent attributes.  

reference:  http://www-01.ibm.com/support/docview.wss?uid=

Conditional expression syntax | IBM Maximo

You enter conditional expressions using a syntax similar to Structured Query Language (SQL) with some additional variables.

When you create a conditional expression, use a colon (:) to define a variable. The colon is used to avoid ambiguity when you create expressions that relate the current record to a different, specific record.

You can have subselect in an expression,

exists (select 1 from workorder where wonum=:wonum).

The first wonum is the wonum attribute on the work order object. At run time, the second wonum is replaced with the value of the wonum attribute for the current record.

Display Assigned GROUPNAME with WONUM in Workorder Tracking | IBM Maximo

 I had a requirement from my client to show the Workflow Assingee PERSONGROUP in front of WONUM in Workorder tracking applicaton's list view.

display assigned PERSONGROUP name in WORKORDER application's list view.

 1. create a new Relationship from ASSIGNEE to PERSONGROUPTEAM, remaining are OOTB

How to Delete Custom Applications from Maximo | IBM Maximo

Note: First of all shut down application server before going to delete an application.

run these SQL commands one by one:

delete from maxapps where app='CSPINSPECTION';
delete from maxpresentation where app='CSPINSPECTION';
delete from sigoption where app='CSPINSPECTION';
delete from applicationauth where app='CSPINSPECTION';
delete from maxlabels where app='CSPINSPECTION';
delete from maxmenu where moduleapp='CSPINSPECTION' and menutype!='MODULE';
delete from maxmenu where elementtype='APP' and keyvalue='CSPINSPECTION';
delete from appdoctype where app= 'CSPINSPECTION';
delete from sigoptflag where app='CSPINSPECTION';
delete from wfapptoolbar where appname='CSPINSPECTION';

Now just start the application server, deleted application is now longer available. Wasn't that simple.

if you added any system XMLs for your app (like lookups), then you will need to export the System XML and manually remove them and then re-import. (Or just import the copy of the system XML you should have made before you started. 

Add a Combo-box Control in PR using ALN Domain or Object in Database Configuration | IBM Maximo

My client requirement is to have of combo-box (dropdown control) instead of domain(magnifier) for SHIPVIA in Purchase Requisition application Main tab.

Object is: PR
attribute is: SHIPVIA of PR object
DOMAINID in database configuration attach to SHIPVIA of PR object: SHIPVIA  (ALN domain name)

Enabling an existing Hover Window in any Attribures | IBM Maximo

By default a some of hover dialogs are set on various application. You can enable existing hover windows on fields to suit your needs. For example, you can add a hover window to show the contact details for the owners of service requests. In general, you can show related information on any fields that support lookup.
If we analyze the properties Advance Tab of these text fields in application designer, we will get to know that there is something in Hover Window ID: field

below is a sample of these four examples and Hover dialog keywords
Hover Window ID:

- Asset               ASSET_RECORDHOVER
- Item                ITEM_RECORDHOVER
- Person             PERSON_RECORDHOVER   
- Work Order    WO_RECORDHOVER

How to Add lookup to a custom field? | IBM Maximo

In this example we are going to create a new custom field in work order tracking application. And then we are going to attach a lookup to select existing people records.

1. Create a new Table domain in Domain Application
   
• Domain:    myPersonDomain
• Object:        PERSON
• Validation where clause:    personid = :myCustomField (same name as field in application) 

Restrict default behaviour, Auto-Population of Asset Field everytime I select Location | IBM Maximo

use a simple Automation script to restrict this behavior because sometime work orders are opened against Location only.


A small Attibute automation script (ALP):

Business object:  WORKORDER
Attribute: LOCATION
Variable: vASSETNUM bind with ASSETNUM of object WORKORDER

copy and paste below mentioned code:

if  vASSETNUM is not None:
        vASSETNUM=None

Custom Field in Non-persistent Object ISSUECURRENTITEM | IBM Maximo

Add a new field in ISSUE CURRENT ITEM dialog and capturing the data in the MATUSETRANS table using automation script.

if owner and owner.getRecordMboName()=="INVENTORY": issueitemMbo=owner.getMboSet("ISSUECURRENTITEM").getMbo(0) if issueitemMbo: mbo.setValue("MATUSETRANScustomaFieldName", issueitemMbo.getString("ISSUECURRENTITEMcustomFieldName"))

Thanks to SASHULL

Maximo Safetyplan and associated Hazard n Precautions SQL | IBM Maximo

select
      sp.safetyplanid
      , sp.description
      , h.hazardid
      , h.description
      , p.precautionid
      , P.description
      , p.siteid
  from
      safetyplan sp
  join
      spworkasset spwa
      on sp.safetyplanid = spwa.safetyplanid
  join
      splexiconlink spll
      on spwa.spworkassetid = spll.spworkassetid

Modify Label using Conditional Expression | IBM Maximo

1. signature option new or existing (e.g. READ)
2. In Advance:
Security Group: EveryOne
Condition: our condition (e.g. :status = 'APPR')
Property: label (if condition true)

value "status is approved"

Property(if false) label (if condition false)

value "Status is not approved"
 

Invoke an Action (i.e. Change Status) with Push Button | IBM Maximo

1. Create New Action:

    Name: statusApprAction ( for example)

    Object: PR
    Type: 'Change Status'

    Value: 'APPR'

2. Open desired application  (for example, Purchase Requisition in Application Designer
    Create a new Signature Option in desired application using application designer

    New/Option: statusApprSig
    Advanced Signaure Option: Check This is an action that must be invoked by user in the UI

Wrong Date Format When We Download from List Tab | IBM Maximo

1. Go to System Configuration > Platform Configuration > System Properties
2. Find/filter property : webclient.downloaddatetimeastext
3. In "Global Value" field change the value to 1
4. Select the row and click "Live Refresh" action
5. We are done :)

Excluding Attributes Data (user-defined) When Duplicating Records | IBM Maximo

This is only for user-defined attributes and not for out of the box attributes.

1. In Database Configuration, filter your object e.g Assets
2. Click Exclude Attribute Data from Select Action
3. select the attributes that you want to exclude for this object, even you can use conditional expression over here.
4. run Apply Configuration Changes to take effect
you are done :)

DOCLINKS Configuration (Attachments) | IBM Maximo

1. Create your doclinks folder
Create a folder, e.g. c:\doclinks
and a sub-folder, e.g. c:\doclinks\default

2. Configure System Properties
You need to configure the following system properties

• mxe.doclink.doctypes.defpath => c:\doclinks\default
• mxe.doclink.doctypes.topLevelPaths => c:\doclinks
• mxe.doclink.path01 => c:\doclinks=http://<servername>/doclinks

Restart your MXServer.

3. Change httpd.conf (e.g. in my case C:\IBM\HTTPServer\conf\httpd.conf)
Open the httpd.conf and add the following section to the end of the file

Alias /doclinks "D:/doclinks"
<Directory "D:/doclinks">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Custom Power App for Desktop Requisition XML | IBM Maximo

Once we modified OOB Desktop requisition  to Power App, Presentation is as below:

<?xml version="1.0" encoding="UTF-8"?>
<presentation id="mymr" ismobile="false" mboname="MR" resultstableid="results_showlist" version="6.0.0">
<page id="mainrec" scroll="false">
<include controltoclone="pageHeader" id="INCLUDE-pageHeader"/>
<clientarea id="clientarea">
<tabgroup id="maintabs" style="form">
<tab default="true" id="results" label="List" type="list">
<menubar event="search" id="actiontoolbar1" sourcemethod="getAppSearchOptions"/>
<table id="results_showlist" inputmode="readonly" label="Requisitions" mboname="MR" selectmode="multiple">
<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="results_showlist_tablebody">
<tablecol dataattribute="MRNUM" filterable="false" id="results_showlist_column_select" mxevent="toggleselectrow" mxevent_desc="Select Row {0}" sortable="false" type="event"/>
<tablecol dataattribute="MRNUM" id="results_showlist_column_link" mxevent="selectrecord" mxevent_desc="Go To %1" type="link" usefieldsizegroup="false"/>
<tablecol dataattribute="DESCRIPTION" id="results_showlist_column3"/>
<tablecol dataattribute="SITEID" id="results_showlist_column1"/>
<tablecol dataattribute="REQUESTEDBY"

How to setup e-signature on Asset Application | IBM Maximo

Goto > System configuration > Platform configuration > Database Configuration
1 filter Asset application
  and in Attribute Tab, find desired
2 and Enable Check Box "E-Signature Enabled"
Save
3 Now Manage eSig Actions from Select Action
 filter Asset application
 and filter "Save Asset" in Option for Add Assets in Collection
4 and Enable Check Box "E-Signature Enabled"
5 Run Database Configuration, and you are done :)

Launch in Context, Add Hyperlink on SR to IBM Portal | IBM Maximo

navigation: Goto > System configuration > Platform configuration > Launch in context
1 click new
Launch Entry Name: IBM    Description: IBM Support Portal
console URL: http://www.google.com/portal :) hehe
Target Browser Window: _blank
2 Click New Row button to add Launch Context for Launch Entry
Resource Object Name: SR
3 Hit Save
----------------------------------------------
Navigation: Goto > System configuration > Platform Configuration > application Designer
open SR application
1 Add new Signature Option from action menu
     i New Row button to add new row
        Option: IBM    Description IBM Support Portal
    ii Expand Advanced Signature Option
        Check radio button: Associate to launch entry to enable launch in context
    Launch in Context Name: IBM
2 Hit OK

Insert Image in PEOPLE application like in ITEMMASTER | IBM Maximo

Insert Image in PEOPLE application like in ITEMMASTER | IBM Maximo

1.    Create a Relationship on PERSON Object to IMGLIB

(REFOBJECT = 'PERSON' AND REFOBJECTID = :PERSONUID)

Embed Maximo into your own webpage PORTALMODE | IBM Maximo

client requirement is to embed Maximo Login Page into his company's website, for that Maximo offer a switch PORTALMODE=true to append into URL.

for example, in html as a hyperlink

 <body>
<A href="http://10.50.87.20:9080/maximo/ui/maximo.jsp?portalmode=true" target="ifr">Maximo Login</A><BR>

  <TD>
    <IFRAME name="ifr" width="700" height="500"></IFRAME>
  </TD>

</body>

Reassign button in Workflow (Display One) | IBM Maximo

A Reassign button in workflow at Manual Input Node, sometime we need or sometimes we don't.
Reassignment of an assigned task from your inbox to other is a useful option in Maximo;

below mentioned is the way to enable or disable this option when you click on Route button.
Open your desired workflow in Workflow designer,

Disabling e-Signature When Managing Admin Mode | IBM Maximo

Navigation: Go to > System Configuration > Platform Configuration > Database Configuration

Click on Manage eSig Action from Select Action Filter Database Configuration and below you will find enabled E-signatures for Manage Admin Mode and all like that. Deselect them and hit Save. You are done.