Maximo Anywhere 7.5 Configuration - Adding a New QueryIn 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.
SummaryIn 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:
PrerequisitesIt is assumed you already installed Maximo Anywhere 7.5, and built and deployed the Work Execution App to your Mobile Device, as described in the infocenter. Before you start this scenario, make a copy of the Work Execution application artifact (by default: \IBM ) in case you want to go back to the original configuration.
Step 1 - Determine the query name in MaximoThe 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: Click on 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 queriesNow 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):
<view i
saveonshow="true" show
<queries reso
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 resourceNext 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
<resource prov
desc
name="workOrder" pageSize="200" clas Add
<queryBase nam to the list as in bold below. The order does not matter in this data section. <queryBases> <!-- list of query bases the app will rely upon for this resource -->
</queryBases>
Step 4 Build and deploy the appFollow your regular build and deploy procedures on Maximo Anywhere, for example: build.cmd all 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. Ana Biazetti |