Maximo Anywhere 7.5 Configuration - Adding a New Query
anabia 060000VR13 Comments (3) Visits (6834)
In this blog we will work through an example of adding a query to Maximo Anywhere Work Execution App. This is a typical setup/configuration that is done after initial install of the Maximo Anywhere solution, where the Work Execution App is tailored to show the appropriate Work Orders that the technicians need to see/work on a daily basis in the customer environment.
In this scenario, we will add a Query from Maximo Work Tracking app as a Query Base to show on the Work Order List in the Work Execution App.
We will edit the app.xml for Work Execution App and change 2 sections:
Before you start this scenario, make a copy of the Work Execution application artifact (by default:
) in case you want to go back to the original configuration.
Step 1 - Determine the query name in Maximo
The first step on this scenario is to determine which query you want to use for your Maximo Anywhere Technicians. You may reuse an existent query in Maximo, or define a filter on Work Order Tracking that results in Work Orders you want to see on the Work Execution app.
In this example we will create a new query in Maximo Server: “REPORTED_BY_ME”.
This must be a public query on the Maximo Work Order Tracking Application.
In the maximo UI, start with
Go To -> Work Order Tracking
Define a filter to see the work orders, then save the filter as a new query.
In this example we will use a query which returns the Work Orders reported by the current user:
reportedby = (select personid from person where personid = (select personid from maxuser where userid = 'WILSON' ))
Save the query as public:
Save Query -> View/Manage Queries
you should see the “REPORTED_BY_ME” query:
Make sure to note the exact Query Name, as you will use it in the next steps. The Query Name is case sensitive.
Also, to make sure this query results in valid Work Orders for specific users, login as such an user in the Maximo UI and select this query such that you can see the Work Orders that should also appear on the Work Execution App.
Step 2: In app.xml, ui section, add query to WorkItemsView queries
Now we will access the Maximo Anywhere environment and change the Work Execution app artifact: app.xml.
Add <query label="Reported by Me" quer
As the first query under <queries> for the WorkItemsView (in bold below):
You can choose any label you want (here I used “Reported by Me”), but the queryBase must be the exact Query Name as in Maximo.
The order of the query on the queries element determines the order the queries show on the screen dropdown menu. As we added the new query as the top one, it will be the one to be shown when you first login on the Work Execution App.
Step 3 In app.xml, data section, add queryBase to WorkOrder resource
Next step is to update the data section of the app.xml.
Look for the content below in the data section of the app.xml. This describes the queryBases available for the WorkOrder reso
name="workOrder" pageSize="200" clas
to the list as in bold below. The order does not matter in this data section.
<!-- list of query bases the app will rely upon for this resource -->
Step 4 Build and deploy the app
Follow your regular build and deploy procedures on Maximo Anywhere, for example:
Assuming you had already installed the Work Execution App on your device, when you try to use it you will receive an update, and then the app will show the new query “Reported by Me” on the tool of the app, and the resulting work orders on the Work Order list.
When you click on "Reported by Me" you should see the previous queries that were already setup for the Work Execution App. You can switch the query by clicking in any of them.
For more information on Maximo Anywhere Configuration, see this infocenter topic.
I hope you found this scenario useful. We will provide additional scenarios for configuration of Maximo Anywhere in follow on blogs. Please let us know of your comments or specific requests.