At the first MaxTECH meeting, 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 query.
So, they created a table called QUERYPERSONGROUP and modified the 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 attached 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 ask!
------------------------------
Helen Fisher
Marketing Manager, BPD Zenith
Happy to be contacted at
helen.fisher@bpdzenith.com------------------------------