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