Maximo Open Forum

 View Only

  • 1.  Generate a list of workorders that contain attachments directly in Maximo

    Posted 21 days ago

    Hello guys!

    Maximo 7.6.1.3 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.

    Danny


    #Administration
    #Customizations
    #MaximoUserGroups

    ------------------------------
    Danny Cordeau
    Universite de Sherbrooke
    ------------------------------


  • 2.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 18 days ago

    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.



    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------

    Original Message


  • 3.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 18 days ago

    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).



    ------------------------------
    Stephen Hume
    Sheffield Scientific LLC
    ------------------------------

    Original Message


  • 4.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 18 days ago

    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.



    ------------------------------
    Stephen Hume
    Sheffield Scientific LLC
    ------------------------------

    Original Message


  • 5.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 18 days ago

    Hi Stephen,

    Here is my SQL Query :

    SELECT wonum,
    description,
    status,
    workorderid
    FROM workorder
    WHERE 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!!

    Danny



    ------------------------------
    Danny Cordeau
    Universite de Sherbrooke
    ------------------------------

    Original Message


  • 6.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 18 days ago

    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.



    ------------------------------
    Craig Kokay
    Cosol
    ------------------------------

    Original Message


  • 7.  RE: Generate a list of workorders that contain attachments directly in Maximo

    Posted 17 days ago

    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!

    Danny



    ------------------------------
    Danny Cordeau
    Universite de Sherbrooke
    ------------------------------

    Original Message