THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Nov 28, 2017

Limit the Number of Queries Visible in an Application in Maximo

At the MaxTECH User Group last week, one of the attendees came up with the idea that it would be great if you could identify a persongroup or persongroups to see a specific public query in an application.
So, they created a table called QUERYPERSONGROUP and modified their Query Manager application to allow the user to add persongroups to a query.
We then set up a conditional expression that will only display a query under the following conditions: If the user is the owner it will be displayed, if it is a PUBLIC Query and there are no persongroups linked to the query it will be displayed, and finally if it is a PUBLIC Query and there is a persongroup and the user is in the persongroup it will be displayed.

This conditional expression is used in the Security Groups application for the MAXEVERYONE security group as a Data Restriction on the QUERY Object. It applies to all applications in Maximo.
The screenshot below shows the list of queries for the Work Order Tracking Application (T&D) and highlights that only 1 public query is being displayed. There are 2 public queries, but the second one is only supposed to be displayed if you are a member of a specific persongroup.

This is a GREAT way to manage the huge list of queries that can populate an application in Maximo.
If you would like to see the complete implementation instructions for this enhancement to Maximo please contact me directly.  Full credit goes to Jason Kingdon for the idea and we collaborated on the solution.

Stephen Hume

Stephen Hume

Stephen Hume is a seasoned Maximo Consultant working for BPD Zenith (Canada). He is a keen presenter at the following user group meetings: Facility Management Maximo User Group, Maximo Utility Working Group, Western Canada Maximo User Group, Canadian Maximo User Group, IBM Pulse, IBM Interconnect. His presentation topics have included; Upgrade Lessons Learned; Health Safety and Environment in Maximo; Mobile Incident Reporting using Maximo Anywhere; How to Prepare for and Survive an IBM Audit; Throw Away the Log Books with Maximo Operator Logs.

0 Comments

Maximo Inspection Forms extension for Procurement

Maximo Inspection Forms extension for Procurement

Since the release of Maximo Work Centers, Inspection Forms have gained popularity in the work management circles, however, this powerful tool seems to be under-utilized for Maximo’s purchasing module. The below is an attempt to harness the potential for procurement. A...

What’s new in IBM Maximo version 7.6.1.2

What’s new in IBM Maximo version 7.6.1.2

IBM released Maximo v 7.6.1.2 on July 24, 2020 to bring new and enhanced functionality to the user community of a leading, world-class asset management solution. IBM continues to assist the Maximo community optimise and enhance the performance of their assets while...

An Introduction to the Service Requests Work Center

An Introduction to the Service Requests Work Center

Service Requests Work Center The Service Request tool is used to create service requests, monitor the status of existing active requests as well as view completed requests. You have the ability to create SRs on your desktop computer, laptop computer, or mobile device....

Digitalization, Remote Operations and Smarter Maintenance  

Digitalization, Remote Operations and Smarter Maintenance  

As the effects of COVID-19 continue, it is reasonable to consider that the ‘new normal’ may be with us for some time. To preserve the long-term health of your organization in these unprecedented times, the value of data to inform activities cannot be overstated.  What...

Crew Management using Graphical Scheduling applications

Crew Management using Graphical Scheduling applications

Maximo Scheduler applications have been around for a while, but some great design enhancements and functionalities released by IBM in the recent versions; and the fact that it provides maintenance planning and scheduling capabilities within Maximo eliminates the need...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Listen to your assets!

Most companies are aware of waste in their preventative maintenance efforts, but aren’t quite sure how to eliminate it.