Maximo

Maximo

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

 View Only

  • 1.  Sort rows in table window (ascending or descending)

    Posted Tue November 09, 2021 01:42 AM
    MAM 7.6.1.2:
    In the Classifications application --> Children table window:

    I want to sort the rows in the Children table window:
    CGACTIVE desc, CLASSIFICATIONID asc

    Is there a way to do that?


    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Sort rows in table window (ascending or descending)

    Posted Tue November 09, 2021 03:21 AM
    Edited by System Admin Wed March 22, 2023 11:52 AM

    #AssetandFacilitiesManagement
    #Maximo


  • 3.  RE: Sort rows in table window (ascending or descending)

    Posted Tue November 09, 2021 09:50 PM
    Edited by System Admin Wed March 22, 2023 11:53 AM
    I think I was just right-clicking the wrong thing in Application Designer.

    If I right click the Children table window and go to its properties, I see that there is an Order By field. It works as expected.


    #Maximo
    #AssetandFacilitiesManagement


  • 4.  RE: Sort rows in table window (ascending or descending)

    Posted Wed November 10, 2021 09:48 PM
    Edited by System Admin Wed March 22, 2023 11:51 AM
    By the way, it looks like it's also possible to put an ORDER BY clause in the relationship WHERE clause. That worked for this requirement too.

    Although I noticed that if I put the ORDER BY in both the application design, and in the relationship, that ended up breaking things. When I entered a new child WO into the Children table window, Maximo didn't populate the PARENT field of the new classification. So it ended up being an orphan.
    Not that I needed the ORDER BY in both places. But it makes me think that putting an ORDER BY in the relationship might be a bad practice.

    #AssetandFacilitiesManagement
    #Maximo