Maximo

Maximo

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

 View Only

  • 1.  Use a conditional expression in a WHERE clause?

    Posted 11/17/21 04:46 PM
    Edited by System Admin 03/22/23 11:48 AM
    MAM 7.6.1.2:

    Are there any places in Maximo where we can use conditional expressions in SQL WHERE clauses?
    Examples:
    1. Escalation WHERE clause
    2. Relationship WEHRE clause
    3. List View WEHRE clause
    4. Others?

    I was reminded recently that the logic behind a conditional expression can be an automation script (instead of SQL or Java). I wondered if that might provide some interesting opportunities. 
    For example, in an SQL WHERE clause, we could reference a condition (that is an automation script) that does an HTTP call to an external web service. Return a value of 1 or 0.


    Related:
    Escalation: Use an Action to get a value and return it as a bind variable?
    RFE: 'Get Value' action type
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Use a conditional expression in a WHERE clause?

    Posted 11/29/21 08:10 PM



Related Content