Maximo

Expand all | Collapse all

" If you want to change how values are searched for in a specific field, you can edit the SQL where clause for a field."

  • 1.  " If you want to change how values are searched for in a specific field, you can edit the SQL where clause for a field."

    Posted Sun September 19, 2021 02:55 PM
    Edited by User1971 Wed September 22, 2021 07:59 PM

    The documentation for Maximo wildcard searches says this (first paragraph):

    "You can use special characters to search when you do not know the entire value that you want to search for or when you want to specify the type of information that you are searching for. The type of value that is used in a field, such as a numeric or string value, determines which operators can be used to filter for values in the field. If you want to change how values are searched for in a specific field, you can edit the SQL where clause for a field."
    https://www.ibm.com/docs/en/maximo-eam-saas?topic=searching-wildcards-operators

    What does that last sentence mean? How can we "edit the SQL where clause for a field"?



  • 2.  RE: " If you want to change how values are searched for in a specific field, you can edit the SQL where clause for a field."

    Posted Wed September 22, 2021 04:39 PM
    It means you can modify the compiled search criteria by using the Where Clause option under Advanced Search. Later in the article it states ....

    The WHERE Clause

    You can edit the WHERE clause to change how values are searched for in a specific field. To edit the WHERE clause, add a value to a field and then select Advanced Search > Where Clause. If you are searching for null values by editing the WHERE clause, you use the SQL comparison values IS NULL and IS NOT NULL to select and compare null values.



    ------------------------------
    John Rice
    ------------------------------



  • 3.  RE: " If you want to change how values are searched for in a specific field, you can edit the SQL where clause for a field."

    Posted Wed September 22, 2021 08:01 PM
    Edited by User1971 Wed September 22, 2021 08:01 PM

    Thanks. The references to specific fields were throwing me off. I see now what they were trying to say, they just worded it weirdly.

    Cheers.