Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Why is the contains operator used in list view WHERE clause?

  • 1.  Why is the contains operator used in list view WHERE clause?

    Posted 8 days ago
    Edited by User1971 8 days ago
    I've noticed that Maximo uses Oracle's CONTAINS operator when I do a wildcard search on description fields:

    (contains(description,'$park') > 0 ))

    What is the rationale behind using CONTAINS rather than a more common operator such as LIKE?

    Thank you.


  • 2.  RE: Why is the contains operator used in list view WHERE clause?

    Posted 7 days ago
    If you look in Database Configuration for workorder.description you will likely see the SEARCHTYPE set to 'TEXT' which leverages a number of rules and non traditional searching. For more info, look here https://www.ibm.com/support/pages/understanding-search-methodologies

    workorder.assetnum has a SEARCHTYPE (out of the box) of 'WILDCARD' which is what I think you are looking for. 

    Since it is a DB Config that you can change, or you can train users to the new approach, or some combination that works for you. 

    You can query maxattributecfg to find them all, but the list is long; between wildcard and text you will probably get into the 10K range. 


    ------------------------------
    christopher winston
    ------------------------------



  • 3.  RE: Why is the contains operator used in list view WHERE clause?

    Posted 7 days ago
    CONTAINS is a powerful search tool that uses a context index, which builds a kind of word tree which can be searched using the CONTAINS search syntax. It can make use of TEXT search indexes and performance is greater.

    ------------------------------
    Maarten Brouwers
    ------------------------------