Data Rule using SQL 'IN' logic

[sohasaid]

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?

[ray.wurlod]

For a small enough list of asset data, use in_reference_list check. For larger list use in_reference_column. Use a virtual table in IA to establish the "join".