Maximo

 View Only
Expand all | Collapse all

Object structure: Define field sort order for flat file export

  • 1.  Object structure: Define field sort order for flat file export

    Posted Thu November 25, 2021 09:41 PM
    Edited by System Test Wed March 22, 2023 11:47 AM
    MAM 7.6.1.2:

    I have an object structure that I use to export to flat file.

    Is there a way to control the field sort order? (field sequence in Excel/CSV)






    It looks like Maximo orders the fields in alphabetical order. I'd rather define my own sort order.

    Thanks.
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Object structure: Define field sort order for flat file export

    Posted Mon November 29, 2021 09:08 AM
    I'm honestly not sure order is managed at all today. Looking at your example sort it doesn't look like it is sorted alphabetically. Testing the REST API it seems random too (it's not in the order of the oslc.select, nor is it alphabetical, nor is it based on the attributeno on the MAXATTRIBUTE record). This makes sense to me as integrations typically aren't position sensitive and there really isn't a place to record the order today.

    ------------------------------
    Steven Shull
    ------------------------------

    Original Message