Maximo

Maximo

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

 View Only
Expand all | Collapse all

Searching for records using Parent Classification and Classification fields on List tab

  • 1.  Searching for records using Parent Classification and Classification fields on List tab

    Posted 07/17/22 07:31 AM
    Hello Everyone

    We are using Classifications on certain records, e.g. Items, WOs etc.

    The issue which we are facing is that user want to have columns for searching on List tab.

    When we add Parent Classification and Classification on List tab, then these columns are not sortable... Also, on list tab we cannot use the hierarchy of classification.

    Our users are not very happy to use the out-of-the-box searching functionality for Classification, hence, asking to provide this on List tab

    any idea how to resolve:

    1) Providing hierarchy on classification filter fields on List tab
    2) Providing sorting on classification filter fields on list tab

    any other idea on this ??

    ------------------------------
    mx pro
    ON
    ------------------------------

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Searching for records using Parent Classification and Classification fields on List tab

    Posted 07/18/22 08:26 AM
    The hierarchy path is never stored in the database persistently so you can't search on it without building a customization to have it in the database. For example, at my previous job we created a database view that had the classstructureid and the hierarchy path to enable easier reporting. In that scenario, you could create a relationship to this object and then enable searching that way.

    Sorting on classificationid isn't possible because you're going through a relationship from the child object (such as WO) to the CLASSIFICATION object. Maximo doesn't support sorting through relationships in the classic UI. The value stored on records (CLASSSTRUCTUREID) could be sorted but isn't much use by itself.

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