Maximo Open Forum

 View Only
  • 1.  Can the Attachments folder autosort alphabetically instead of by date uploaded when a user clicks to open it?

    Posted 10-13-2023 13:33

    Is it possible to have the Attachments folder auto-sort alphabetically instead of by date uploaded?  I didn't know if there was a setting that could be changed in the back end.

    Thank you in advance.


    #Administration
    #Assets
    #Customizations
    #EverythingMaximo

    ------------------------------
    Danny Richardson
    Maintenance Administration Facilities
    Technimark LLC
    ------------------------------


  • 2.  RE: Can the Attachments folder autosort alphabetically instead of by date uploaded when a user clicks to open it?

    Posted 10-13-2023 15:37

    There isn't a setting but I believe you could export the Library XML in Application Designer (Select Action->Export System XML and click the export button next to LIBRARY), find the dialog id="viewattachments", and on the table add orderby="createdate desc". IE your table would look something like:

    <table id="viewattachments_table" inputmode="readonly" orderby="createdate desc">

    Save your local file and then import back into Application Designer. Give it ~2 minutes to synchronize through the cluster and test it again. 



    ------------------------------
    Steven Shull
    IBM
    ------------------------------



  • 3.  RE: Can the Attachments folder autosort alphabetically instead of by date uploaded when a user clicks to open it?

    Posted 10-16-2023 11:22

    Thank you @Steven Shull.  This would be to order by the date created correct?  So instead of "createdate" could you suggest what I would put for alphabetical? 



    ------------------------------
    Danny Richardson
    ------------------------------



  • 4.  RE: Can the Attachments folder autosort alphabetically instead of by date uploaded when a user clicks to open it?

    Posted 10-16-2023 14:16

    Sorry, not sure how I misread it like that.

    The problem is the file details are going to be coming from the DOCINFO table and not the DOCLINKS table which is what the table is based on. We can display data from related tables (and we do to display the description) but you cannot sort based on a child table like that because of the way Maximo builds the queries. 



    ------------------------------
    Steven Shull
    IBM
    ------------------------------