Maximo

Expand all | Collapse all

Use automation script function( ) in relationship where clause?

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

    Posted Sat September 11, 2021 08:16 PM
    Edited by User1971 Wed September 15, 2021 12:20 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 (with out 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



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

    Posted Mon September 13, 2021 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 Sun September 19, 2021 01:25 PM

    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