Maximo

Maximo

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

 View Only
  • 1.  Sort option is not working in nonpersistent column of maximo

    Posted Wed March 08, 2023 03:58 AM

    Hi, 

    Sort option is not working in nonpersistent column of Maximo.Is there any way to fix this? I need to be able to sort and filter on these non-persistent column attribute?



    ------------------------------
    Faryal Amjad
    ------------------------------

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Sort option is not working in nonpersistent column of maximo

    Posted Wed March 08, 2023 01:19 PM

    This isn't possible in the classic UI. We utilize the database for searching & sorting and a non-persistent attribute isn't stored in the database (at least on that object) so neither is possible. In the new UI framework we are able to do this client side which allows us to do it as long as we have all the data available. 



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



  • 3.  RE: Sort option is not working in nonpersistent column of maximo

    Posted Thu March 09, 2023 02:17 AM

    What do You mean by "new UI framework"? Is that MAS8?



    ------------------------------
    Juris Flugins
    ------------------------------



  • 4.  RE: Sort option is not working in nonpersistent column of maximo

    Posted Thu March 09, 2023 09:15 AM

    I'm referring to the Maximo Application Framework which is how we're building our new Maximo Mobile and role-based applications like the new Scheduler Dashboard, Reliability Engineer, etc. This is used in MAS (and on 7.6.1.X if you install Maximo Mobile to it) but only on these newer applications. There are times where we still execute the search (filter) on the server using the Maximo REST API because we might only have a subset of the data locally. In those situations, the same limitation would still apply for filtering today. But other times where we know we have the data we can do the filtering and sorting client side which avoids any limitation or performance impact. 

    Applications that you create or modify via Application Designer are going to look slightly different in MAS but have the same technical foundation and limitations. Because we will only have say 20 records available at a time (even though we know the count, we don't actually fetch all the records), when someone chooses to filter or sort we pass that information on to the database to execute.



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



  • 5.  RE: Sort option is not working in nonpersistent column of maximo

    Posted Thu March 09, 2023 09:18 AM

    Thank You for clarification!



    ------------------------------
    Juris Flugins
    ------------------------------



  • 6.  RE: Sort option is not working in nonpersistent column of maximo

    Posted Thu March 09, 2023 07:02 PM

    Howdy,

    In addition to Stephen's reply, depending on whether the data is calculated or coming from another object, you could possibly use crossover data to persist the data onto the main object in your application. The UI you are showing looks to be 7.5ish.  If you are in fact in a version that old you might have a more or less difficult time with the above approach.  In newer versions (7.6.0.9 and later) you have automation scripts right? ;) So if calculations are needed and the data is coming from other objects then it is possible to populate the data into an extra column.  Then you could sort it.



    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------