Updating or Changing the ownership of an existing query in Maximo

June 30, 2016 RobertoG.Palma

In Maximo you have public queries created by an user and then you may want to change the ownership of the queries, for example, when you have some Maximo public queries created by an user that left the company, and you need to change the ownership of those public queries so that you can update the queries

As for changing the public query ownership in Maximo, by design, some "User A" cannot change a query which has been created by "User B". It was designed based on the saved query function. 

You would need to connect your Database and backend change the query ownership with a simple edit from QUERY table the OWNER field is the user who wrote(saved) the query, change this value to set the new owner. 
 
The only known workaround to take ownership of a query created by another user is to update the "owner" of that query via the back-end (sql update). 
 
For your information all queries created/saved by a user as Public will be displayed under the View/Manage Queries list of all users. 

These queries cannot be deleted by any other users including maxadmin from View/Manage Queries list. Only the creator of the query can delete the query. 
 
If needed, the following workarounds can be used by maxadmin to disable/delete any user's queries from appearing in other users' View/Manage Queries list. 
 
To make the query accessible only to the creator: 
update maximo.query set ispublic=0 where queryid=xx ; 
 
To delete the query: 
delete from maximo.query where queryid=xx ; 
 
Additional info can be found at : 
 
Deleting End User created Queries 
http://www-01.ibm.com/support/docview.wss?uid=swg21648649

 

Thanks

Previous Article
Cannot duplicate application in Application Designer

You are working with Application Designer in Maximo and duplicated the Assets application without a problem...

Next Article
Maximo 7.6.0.5+ : Installing Standalone Help
Maximo 7.6.0.5+ : Installing Standalone Help

Maximo Asset Management Feature Pack 7.6.0.5 changed the way Maximo help works. Instead of building and dep...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!