Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Portlet Not Showing records (Work orders) - Maximo Technician

    Posted Fri February 03, 2023 09:47 AM
    Hi Friends,

    I am facing an issue with the maximo start center. The portlet for the maximo technician work orders particularly not showing any work orders either PM Generated or Created. The Problem is facing by all the technicians. Is there any solution to clear this particular issue.

    Any help would be really appreciated.

    ------------------------------
    Ben Kristen
    ------------------------------

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Portlet Not Showing records (Work orders) - Maximo Technician

    Posted Mon February 06, 2023 12:04 AM
    Hello!

    Is that portlet something out of the box?
    What filter (query) is used for it?
    Is that from beginning, or one day started that issue?

    ------------------------------
    Juris Flugins
    ------------------------------



  • 3.  RE: Portlet Not Showing records (Work orders) - Maximo Technician

    Posted Mon February 06, 2023 01:15 AM
    What query are you using and how do you assign the work to the tech? by Lead, Owner, PersonGroup, OwnerGroup, Supervisor, etc. 

    Sample: 

    ((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0) and status !='COMP' and LEAD = (select personid from person where personid = (select personid from maxuser where userid = :USER))


    - Related to the current user being the person assigned as lead (replace 'LEAD' above with reportedby, supervisor, owner, buyer, etc., as needed)

    You can look for more detail here



    ------------------------------
    Thanks,
    christopher winston
    ------------------------------



  • 4.  RE: Portlet Not Showing records (Work orders) - Maximo Technician

    Posted Mon February 06, 2023 12:48 PM
    Howdy Ben!

    As both Juris and Chris have indicated this is about your query on the portlet. Was something working and is now not? Has it ever worked?  If so, what has changed? Are all work orders now no longer visible or just PM work orders?

    BTW not sure what you mean by "work orders either PM Generated or Created." You either have a work order of type PM or you do not.  There is no in-between. You can have forecasted PM Work orders but those are neither generated or "created".  They are simply forecasted and held in memory.  When you save the forecast that data is stored in the PMFORECAST object.

    So going back to your portlet query, if you review the questions that Juris and Chris ask you should likely be able to remove your challenge.  Please let us know what you find!  Thanks in advance!!

    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------



  • 5.  RE: Portlet Not Showing records (Work orders) - Maximo Technician

    Posted Tue February 07, 2023 02:52 PM
    Hi,

    Is this result set customized by you or out of the box? If it is customized one, try to get the query that is running for that portlet. Run it for the users for whom you do not see any records (if it is user specific) in the database. If you do not get any results, try to find out which part of the query is causing the issue and not giving the results.

    ------------------------------
    Suhas Joshi
    ------------------------------