Maximo Open Forum

 View Only

  • 1.  Unable to select employee records

    Posted 07-14-2025 17:26

    Hello everyone,

    I am in need of some help.  I have created a start center and in it an application that tracks work order completed by employees. What I am having a challenge with is that in the start center, when I click on Employee, Work Order, Description, changed date,  nothing shows up, I cannot see any data listed.  What am I doing wrong?

    Thanks in Advance


    #Administration
    #MaximoApplicationSuite
    #WorkCenters

    ------------------------------
    gursev bajwa
    ocwa
    ------------------------------


  • 2.  RE: Unable to select employee records

    Posted 07-16-2025 09:09

    Gursev,

    I think you may be missing some steps that would help with identifying what the issue may be. One thing I like to do when troubleshooting why I am not seeing the expected results, from the newly created result set I would select the "Open Result Set" action that will be on the top row of the Result set. This will take you to the application that is configured for that result set. Once in the application look at the 'Where Clause' depending what version of Maximo this is in different locations. Review the Where clause for accuracy such as if you had used a substitution variable (ie. :&USER&  or :USERID, etc) then did it replace it with the value you expected?

    If that does not help, it would be nice if you provide additional details by what you mean "...when I click on Employee, Work Order, Description, changed date,  nothing shows up". Maybe include the high level steps you used to create the Result Set.

    Mike



    ------------------------------
    Michael Marsonet
    MRM-EAM Consulting Inc.
    ------------------------------

    Original Message


  • 3.  RE: Unable to select employee records

    Posted 07-17-2025 13:18

    So I am using Maximo 7.6.1.3 and my main goal is to to develop an app in the start center which I have:

    and the purpose of the app is to show work order completion by employee.  The function of the app is that users must be able to select an employee and show the work order completion by month.

    This is where I am failing.



    ------------------------------
    gursev bajwa
    ocwa
    ------------------------------

    Original Message


  • 4.  RE: Unable to select employee records

    Posted 07-17-2025 20:40

    Hi Gursev ,

    I'm sorry to say, but that did not provide clear enough information, so I'll respond based on the feature seen in the image.

    Your image that you attached vs the mention of the start center doesn't align.  Why?  Because the dotted lines indicate that this is a screenshot from the Application Designer. As the other columns display correctly, it means you have something wrong with the binding (duh!), i.e., you have the attribute pointing to something that does not exist or has been misspelled.

    Q: Does that attribute exist on the object that the application is supported by?  For example, the Work Order Tracking application is supported by the WORKORDER object.  Therefore, there are attributes WONUM, DESCRIPTION, CHANGEDATE, but not EMPLOYEENAME.

    So, let's assume that EMPLOYEENAME is in fact PERSON.DISPLAYNAME i.e. a person's full name.

    Now, let's use the SUPERVISOR attribute for a work order as a working example.

    ED is the assigned supervisor, but that is not his full name.  This is a code, it just happens in this case that when the person was set-up they used the actual person's name, but that is not the usual case, and instead it could be their employee ID or email address.

    ED's real name is stored in the People application, which is supported by the PERSON object, and the following is ED's information.

    To display the full name in your application, you have to:

    1. Create a relationship between the WORKORDER and the PERSON object with a where clause PERSONID = :SUPERVISOR
    2. Add the field to the UI or the list tab

    Adding it as a field

    Relationship

    Added as on the List tab

    Result for the List tab

    Conclusion

    In conclusion, we can't help if we don't have the information.  I have assumed that you want the person's full name and that it is based on a real field where that data is the person's ID, rather than you have created a crossover domain to copy the full name into a field.

    Please ensure that if this is also to be added as a field on the application, that it is made read-only unless your design says that a user can edit the referenced data.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------

    Original Message


Related Content