Data Rule using SQL 'IN' logic
Posted: Sat Sep 29, 2012 1:31 pm
Hi,
I want to implement the SQL 'IN' logic using a data rule in IA.
The business case is:
Inputs:
- An account has more than one asset.
- Account and asset both have a status.
Required:
- If the account status is active, and at least one asset has an 'Active' status, then the rule is satisfied, else the rule is violated.
Example:
Account data;
Account key, Status
Act1, Active
Asset data:
Asset Key, Status, Account Key
Ast1, Active, Act1
Ast2, Deactived, Act1
Ast3, Suspended, Act1
Based on this example, the rule should be satisfied otherwise it's violated. How to do this in IA?
I want to implement the SQL 'IN' logic using a data rule in IA.
The business case is:
Inputs:
- An account has more than one asset.
- Account and asset both have a status.
Required:
- If the account status is active, and at least one asset has an 'Active' status, then the rule is satisfied, else the rule is violated.
Example:
Account data;
Account key, Status
Act1, Active
Asset data:
Asset Key, Status, Account Key
Ast1, Active, Act1
Ast2, Deactived, Act1
Ast3, Suspended, Act1
Based on this example, the rule should be satisfied otherwise it's violated. How to do this in IA?