Maximo

Maximo

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

 View Only

  • 1.  Numeric Domain Order

    Posted Mon September 21, 2020 11:05 AM
    Maximo 7.6.1

    I am trying to change the numeric domain order from ascending to descending. Is this possible? Maximo automatically changes the numbers in ascending order after saving the numeric domain. I use this domain for lookup in field and want to have descending order there.

    Does anyone know how to change this automatic behavior?

    Thanks. 



    ------------------------------
    Otso Leppälä
    ------------------------------

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Numeric Domain Order

    Posted Tue September 22, 2020 08:32 AM
    That should be doable with a pretty simple configuration. Typically with a domain based field you use the VALUELIST lookup. I would create a new lookup and set an order by on that to sort by value DESC.

    1) go to Application Designer and from the Export System XML export the Lookups XML. Save this to the file system so you can modify it
    2) Copy the table with id="valuelist". Paste it at the bottom, replacing all the IDs inside the table to ensure it's unique (such as emxvaluelist, emxvaluelist_lookup_tablebody, etc.)
    3) On the table element, add a new XML attribute:
    orderby="value desc"
    4) Save and import your file. 
    5) Reference your new lookup in the application(s) where your field is displayed

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------

    Original Message


  • 3.  RE: Numeric Domain Order

    Posted Wed September 23, 2020 01:47 AM
    Thank you very much for the great answer. This was excactly what I was looking for. It works as expected.

    ------------------------------
    Otso Leppälä
    ------------------------------

    Original Message


Related Content