Maximo 188.8.131.52 here. Supervisors want to be able to generate a list of workorders that contain attachments. They want to be able to generate that list as part of the workorder application or directly through their own start center. SQL query is pretty simple and it gives me the expected result but according to you experience what is the simpliest way to deploy that feature? Automation Script?
Thanks in advance.
Easiest would be to take your SQL and make it a Saved Query; and make that Saved Query public. That way your users can get to it in Work Order Tracking, and a Result Set portlet could be configured.The downside to that is, of course, that if only some of your users should have access to the Query, there's no easy way to share the Query with just a group of users. When that happens, you'd have to save the query, go into the database backend and update the owner of that query on the QUERY table (not that backend updates are recommended! And that's assuming you have backend access. . .), then create the query again, backend update that to the next owner, repeat. Or, give (temporary, if they don't normally have it) access to these users to the WHERE clause, help them set up the query, then remove their WHERE clause access if applicable.
Hello Danny, can you convert your sql clause to a Maximo Where Clause and then save it as a query for the users to run themselves. Once it is saved as a query in the work order application, you could also put a resultset on their start center. (Work Orders with Attachments).
workorderid in (select ownerid from doclinks where ownertable='WORKORDER')
You can also limit it to only open work orders by adding "and historyflag = 0" to the query.
Here is my SQL Query :
SELECT wonum,description,status,workorderidFROM workorderWHERE workorderid IN (SELECT ownerid FROM doclinks WHERE ownertable = 'WORKORDER') AND workorder.status IN ('ASSIGNÉ', 'ENCOURS')
That query was converted to a Where Clause, based on your previous post (thanks!) :
workorderid in (select ownerid from doclinks where ownertable='WORKORDER') and status in ('ASSIGNÉ','ENCOURS')
I will now save my query and make it available for my supervisors.
Thanks guys for your help!!
I just want to ask the awkward question as you have said "directly", and everyone's assumption is that the attachment is on "the" work order, not its tasks or related inspections. I ask because each of those have a different OWNERTABLE.
In my case, attachments are indeed part of the Workorder, not its tasks or related inspections. I take good note of your comment relating to the different OWNERTABLE.
Have a nice day!
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE