Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Numeric Domain Order

  • 1.  Numeric Domain Order

    Posted 29 days ago
    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ä
    ------------------------------


  • 2.  RE: Numeric Domain Order

    Posted 28 days ago
    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
    ------------------------------



  • 3.  RE: Numeric Domain Order

    Posted 27 days ago
    Thank you very much for the great answer. This was excactly what I was looking for. It works as expected.

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