Maximo Mobile application object structures and query information

Object structures and queries that are used in the Maximo® Mobile applications.

Assets

Table 1. Object structures and query information for the Assets application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
MXAPIASSET MOBILEMYASSET None None Configured for both. My assets.
MXAPIASSET CREATEDLOCALLY None None Configured for both. Assets that I created.

Inspections

Table 2. Object structures and query information for the Inspections application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
mxapiinspectionres ASSIGNEDWORKTODAY None duedate Configured for both. Assigned inspections.
mxapiinspectionres INSPRESULTPENDING None duedate Configured for both. Pending inspections.
mxapiinspectionres INSPRESULTINPROGRESS None duedate Configured for both. In progress inspections.
mxapiinspectionres INSPRESULTREVIEW None duedate Configured for both. Inspections for review.

To use this query, you must first enable the mxe.mobile.inspection.features.enablereview system property.

mxapiinspectionres INSPRESULTCOMPLETE None duedate Web only. Completed inspections.
mxapiinspectionres INSPRESULTALL None duedate Web only. All inspections.

Inventory Counting

Table 3. Object structures and query information for the Inventory Counting application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
mxapicntbook MOBILECNTBOOK None latestdue Configured for both. Submit counts for count books.
mxapicntbookline MOBILECNTBOOKLINE None
  • nextphycntdate
  • binnum
 Configured for both. Submit counts for count book lines.
mxapiinvbal MOBILEINVCNT None
  • nextphycntdate
  • binnum
  • itemnum
 Configured for both. Submit ad hoc inventory counts.
mxapiinvbal MOBILEINVCNTREC None   Web only. Reconcile balances.
mxapiinvbal MOBILEINVCNTREC pre_curbalchange!=0 pre_curbalchange desc Web only. Reconcile balances that have a discrepancy.
mxapiinvbal MOBILEINVCNTREC pre_curbalchange=0 pre_curbalchange desc Web only. Reconcile balances that do not have a discrepancy.

Inventory Receiving

Table 4. Object structures and query information for the Inventory Receiving application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
MXAPIPO IROPENPOMOBILE None orderdate Configured for both. List purchase orders that are available to receive.
MXAPIRECEIPT CREATEDLOCALLY None None Configured for both. Process receipts that are submitted while the device is in disconnected mode.
MXAPIRCVROTITM   None None Configured for both. Receive rotating assets.
MXAPISHIPMENT IROPENSHIPMOBILE None None Configured for both. List shipments that are available for receiving.

Issues and Transfers

Table 5. Object structures and query information for the Issues and Transfers application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
MXAPIINVUSE MOBILEINVUSAGELIST None None Web only. Used by the Inventory Usage Records action.
MXAPIINVUSE CREATEDLOCALLY None invusenum Mobile only. Used by the Inventory Usage Records action.
MXAPIINVRES MOBILERESLISTISSUE None itemnum Configured for both. Used by the Issue Reserved Items action.

Service Requests

Table 6. Object structures and query information for the Service Requests application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
mxapisr SERVICEREQUEST status in ["INPROG","NEW","PENDING","QUEUED"] reportdate desc Configured for both. Active requests.

For Maximo Mobile 8.11, the status list is set dynamically based on the drop-down list that is selected.
mxapisr SERVICEREQUEST status in ["CANCELLED","CLOSED","HISTEDIT","REJECTED","RESOLVED"] reportdate desc Configured for both. Completed requests.

For Maximo Mobile 8.11, the status list is set dynamically based on the drop-down list that is selected.

Technician

Table 7. Object structures and query information for the Technician application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
MXAPIWODETAIL uxtechnicianownerfilter None priority Configured for both. Defined but not used in Maximo Mobile 8.11
MXAPIWODETAIL ASSIGNEDWOLIST None priority Configured for both. Assigned work. ASSIGNEDWOLIST is the default query.
MXAPIWODETAIL PMWOLIST schedfinish>="&SYSDAY&" && schedfinish<="&SYSDAY&"+7D. priority Configured for both. Preventive maintenance that is due this week.
MXAPIWODETAIL MYWORK None priority Web only. Work that I created.
MXAPIWODETAIL CREATEDLOCALLY None priority Mobile only. Work created on any device.
MXAPIWODETAIL uxtechnicianstatusfilteredwolist None priority Configured for both. My work order.

Use of the uxtechnicianstatusfilteredwolist query is restricted by the MXAPIWODETAIL.uxtechlist sigoption.

MXAPIWODETAIL MOBWORKHIST None priority Configured for both. Work order history.

This query is used to view historical details of work orders and their associated assets and locations. By default, this information is not downloaded.

Work Approvals

Table 8. Object structures and query information for the Work Approvals application
Object structure Query Additional WHERE clause Order by Web or Mobile Description
mxapiwodetail SUPWOTOAPPR None
  • wopriority
  • status
 Configured for both. Work orders to review. SUPWOTOAPPR is the default query.
mxapiwodetail PMWOLIST schedfinish>="&SYSDAY&" && schedfinish<="&SYSDAY&"+7D.
  • wopriority
  • status
 Configured for both. Not used.
mxapiwodetail MYWORK None
  • wopriority
  • status
 Configured for both. Not used.
mxapiwodetail CREATEDLOCALLY None
  • wopriority
  • status
 Configured for both. Not used.
mxapiwodetail uxtechnicianstatusfilteredwolist None
  • wopriority
  • status
 Configured for both. Not used.
mxapiwodetail SUPWOTOCLOSE None
  • wopriority
  • status
 Configured for both. Completed work orders.

By default, completed work orders are not downloaded.
mxapiwodetail MOBWORKHIST None
  • wopriority
  • status
 Configured for both. Work order history.

This query is used to view historical details of work orders and their associated assets and locations. By default, this information is not downloaded.

Lookup and Supporting Data queries

Table 9. Lookup and Supporting Data queries list for applications
Object structure Query Application
MXAPIALNDOMAIN None. Full data is download.
  • ASSETMOBILE
  • SRMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIASSET MOBILEASSET
  • ASSETMOBILE
  • INSPECTION
  • ITMOBILE
  • SRMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIASSETATTRIBUTE None. Full data is download. ASSETMOBILE
MXAPIFAILURELIST FAILUREMOB
  • ASSETMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIINSPFORM MOBILEFORMS INSPECTION
MXAPIINSPFORMUSEWITH MOBILEFORMS INSPECTION
MXAPIINVBAL ACTIVEITEMSITE
  • ITMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIINVENTORY SHOWINVENTORY
  • SUPMOBILE
  • TECHMOBILE
MXAPIITEM SHOWITEMS
  • SUPMOBILE
  • TECHMOBILE
MXAPIITEMCONDITION None. Full data is download. ITMOBILE
MXAPILABOR LABORSITEMOB
  • SUPMOBILE
  • TECHMOBILE
MXAPILABORCRAFTRATE LABORSITEMOB
  • SUPMOBILE
  • TECHMOBILE
MXAPINUMERICDOMAIN None. Full data is download. ASSETMOBILE
MXAPIOPERLOC MOBILELOCATION
  • ASSETMOBILE
  • INSPECTION
  • SRMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIORGANIZATION MOBILEORG
  • ASSETMOBILE
  • SRMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPIPERSON SERVICEREQUEST SRMOBILE
MXAPISYNONYMDOMAIN MOBILEDOMAIN
  • ASSETMOBILE
  • ICMOBILE
  • INSPECTION
  • ITMOBILE
  • SRMOBILE
  • SUPMOBILE
  • TECHMOBILE
MXAPITABLEDOMAIN None. Full data is download.
  • ASSETMOBILE
  • SRMOBILE
MXAPITKCLASS MOBILECLASSSTRUCTURE
  • ASSETMOBILE
  • SRMOBILE
mxapitktemplate SERVICEREQUESTTKTEMPLATE SRMOBILE
MXAPITOOLITEM USERTOOLLIST
  • SUPMOBILE
  • TECHMOBILE
MXAPIVENDOR MXAPIVENDOR ASSETMOBILE
MXAPIWORKTYPE WOWORKTYPE
  • SUPMOBILE
  • TECHMOBILE
MXAPIWPEDITSETTING None. Full data is download.
  • SUPMOBILE
  • TECHMOBILE