Maximo

Maximo

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

 View Only

  • 1.  Use automation script function( ) in relationship where clause?

    Posted 09/11/21 08:16 PM
    Edited by System Admin 03/22/23 11:53 AM
    MAM 7.6.1.2:

    Maximo appears to have a new mechanism that uses Java classes in Maximo relationships.
    For example, the WORKORDER object has a relationship called WOWORKLOG that utilizes a method in a Java class to determine what to return. By referencing mbomethod:getWorkLog, Maximo knows to get the Java class and call the getWorkLog method to determine how to get the set.

    Question:
    Is there a way to do something similar with automation script functions, instead of Java class methods?
    If we could use a automation script (like script:getWorkLog), that would allow us to implement complicated logic that is potentially difficult, inefficient, or too verbose for SQL (without the need for Java/EARs/outage).



    I borrowed the wording above from Steven Shull's comments:

    RFE: Automation script in relationship where clause
    https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-552

    And here's an RFE that's possibly related (not mine):
    New Automation Script Launch Point to Support Roles
    https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-281


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Use automation script function( ) in relationship where clause?

    Posted 09/13/21 08:43 AM
    Good suggestion on the script for a relationship where clause. I definitely support that one. 

    Roles was one I submitted and isn't quite the same. Roles have a special framework in Maximo as they're able to be used in workflow or communication templates to resolve to certain people/email addresses. I believe the automation script framework for roles is actually in Manage 8.1 (latest version in MAS) but I don't have an environment to test in.

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



  • 3.  RE: Use automation script function( ) in relationship where clause?

    Posted 09/19/21 01:25 PM
    Edited by System Admin 03/22/23 11:46 AM

    I wonder if MBR scripts could be used in relationships. It seems like things with colons can often be used in relationships, conditions, etc. If MBR functions have colons, then maybe we could use them in a relationship WHERE clause? Just a guess.

    MBR scripts allow you to create functions pre-fixing the function name with a ":".
    https://nomsamatuer.blogspot.com/2020/04/exploring-mbr-language-scripting-and.html?m=1


    Original Message


Related Content