The original Maximo formulas PDF says:

"...conditions can be any valid condition that Maximo allows, including SQL expressions."

Would someone mind explaining what that means? I don't think I understand how to use SQL expressions in formula conditions.

Thanks.

#AssetandFacilitiesManagement
#Maximo

#Maximo
#AssetandFacilitiesManagement

Formulas allow you to utilize existing conditions defined in Conditional Expression Manager. These have to return a true/false and are often SQL conditions. For example, if you go to conditional expression manager the logic for the condition ASSETMETER is "exists (select 1 from assetmeter where assetnum = :assetnum and orgid =:orgid)" This will use the data on the record you're starting from (IE ASSET or WORKORDER) and look to see if there is a record in the assetmeter table and return true/false back to the formula by executing a SQL query. Then your logic in the IF statement in the formula would take effect.

Conditional expressions can also be written in java or an automation script (by referencing a special java class that invokes the automation script custom condition launch point). In those cases they would not be restricted to SQL expressions. I would imagine you could invoke those too with formulas, though I haven't tried. 

To me, this feature is about supporting existing logic you may have already defined in conditional expression manager while also enabling support for some conditions that the formula framework didn't support today (such as comparing ALN values).

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

Original Message:
Sent: Mon August 16, 2021 09:13 PM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


The original Maximo formulas PDF says:

"...conditions can be any valid condition that Maximo allows, including SQL expressions."

Would someone mind explaining what that means? I don't think I understand how to use SQL expressions in formula conditions.

Thanks.

#Maximo
#AssetandFacilitiesManagement

Hi Steven,
Regarding this line: "...referencing a special java class that invokes the automation script custom condition launch point."
Do you happen to know what that Java class is called?
Thanks.


Original Message:
Sent: Tue August 17, 2021 07:54 AM
From: Steven Shull
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions

Formulas allow you to utilize existing conditions defined in Conditional Expression Manager. These have to return a true/false and are often SQL conditions. For example, if you go to conditional expression manager the logic for the condition ASSETMETER is "exists (select 1 from assetmeter where assetnum = :assetnum and orgid =:orgid)" This will use the data on the record you're starting from (IE ASSET or WORKORDER) and look to see if there is a record in the assetmeter table and return true/false back to the formula by executing a SQL query. Then your logic in the IF statement in the formula would take effect.

Conditional expressions can also be written in java or an automation script (by referencing a special java class that invokes the automation script custom condition launch point). In those cases they would not be restricted to SQL expressions. I would imagine you could invoke those too with formulas, though I haven't tried. 

To me, this feature is about supporting existing logic you may have already defined in conditional expression manager while also enabling support for some conditions that the formula framework didn't support today (such as comparing ALN values).

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

Original Message:
Sent: Mon August 16, 2021 09:13 PM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


The original Maximo formulas PDF says:

"...conditions can be any valid condition that Maximo allows, including SQL expressions."

Would someone mind explaining what that means? I don't think I understand how to use SQL expressions in formula conditions.

Thanks.
#Maximo
#AssetandFacilitiesManagement

The class is com.ibm.tivoli.maximo.script.ScriptCustomCondition

And the value is either the script name or the scriptname:launchpoint

IE EMXWOSCRIPT:EMXWOLAUNCH

I was a bit surprised this isn't in the knowledge center. There's a PDF that covers this on the Integration & Scripting community (current link: https://higherlogicdownload.s3-external-1.amazonaws.com/IMWUC/a5f8259a-b055-73d0-993e-ce349111a62b_file.pdf?AWSAccessKeyId=AKIAVRDO7IEREB57R7MT&Expires=1636380137&Signature=W%2F3Yn47M9uP5AwGceHh3RZI6dZA%3D).

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

Original Message:
Sent: Mon November 08, 2021 12:28 AM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


Hi Steven,
Regarding this line: "...referencing a special java class that invokes the automation script custom condition launch point."
Do you happen to know what that Java class is called?
Thanks.


Original Message:
Sent: Tue August 17, 2021 07:54 AM
From: Steven Shull
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions

Formulas allow you to utilize existing conditions defined in Conditional Expression Manager. These have to return a true/false and are often SQL conditions. For example, if you go to conditional expression manager the logic for the condition ASSETMETER is "exists (select 1 from assetmeter where assetnum = :assetnum and orgid =:orgid)" This will use the data on the record you're starting from (IE ASSET or WORKORDER) and look to see if there is a record in the assetmeter table and return true/false back to the formula by executing a SQL query. Then your logic in the IF statement in the formula would take effect.

Conditional expressions can also be written in java or an automation script (by referencing a special java class that invokes the automation script custom condition launch point). In those cases they would not be restricted to SQL expressions. I would imagine you could invoke those too with formulas, though I haven't tried. 

To me, this feature is about supporting existing logic you may have already defined in conditional expression manager while also enabling support for some conditions that the formula framework didn't support today (such as comparing ALN values).

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

Original Message:
Sent: Mon August 16, 2021 09:13 PM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


The original Maximo formulas PDF says:

"...conditions can be any valid condition that Maximo allows, including SQL expressions."

Would someone mind explaining what that means? I don't think I understand how to use SQL expressions in formula conditions.

Thanks.
#Maximo
#AssetandFacilitiesManagement

Related to ScriptCustomCondition:

Automation Script for Conditional Expressions
Workflow Tip, Script Conditions
Original Message:
Sent: Mon November 08, 2021 12:28 AM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


Hi Steven,
Regarding this line: "...referencing a special java class that invokes the automation script custom condition launch point."
Do you happen to know what that Java class is called?
Thanks.


Original Message:
Sent: Tue August 17, 2021 07:54 AM
From: Steven Shull
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions

Formulas allow you to utilize existing conditions defined in Conditional Expression Manager. These have to return a true/false and are often SQL conditions. For example, if you go to conditional expression manager the logic for the condition ASSETMETER is "exists (select 1 from assetmeter where assetnum = :assetnum and orgid =:orgid)" This will use the data on the record you're starting from (IE ASSET or WORKORDER) and look to see if there is a record in the assetmeter table and return true/false back to the formula by executing a SQL query. Then your logic in the IF statement in the formula would take effect.

Conditional expressions can also be written in java or an automation script (by referencing a special java class that invokes the automation script custom condition launch point). In those cases they would not be restricted to SQL expressions. I would imagine you could invoke those too with formulas, though I haven't tried. 

To me, this feature is about supporting existing logic you may have already defined in conditional expression manager while also enabling support for some conditions that the formula framework didn't support today (such as comparing ALN values).

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

Original Message:
Sent: Mon August 16, 2021 09:13 PM
From: User1971
Subject: Formulas: Conditions can be any valid condition that Maximo allows, including SQL expressions


The original Maximo formulas PDF says:

"...conditions can be any valid condition that Maximo allows, including SQL expressions."

Would someone mind explaining what that means? I don't think I understand how to use SQL expressions in formula conditions.

Thanks.
#Maximo
#AssetandFacilitiesManagement