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

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
------------------------------

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:
Sent: Tue September 22, 2020 08:32 AM
From: Steven Shull
Subject: Numeric Domain Order

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
------------------------------