BCHasRows - Validation with no scripts
Need:
To do validation without using siebel scripts.Solutions:
BCHasRows : Validation Without Scripting
Scenario:
To check/search in child Bus comp field values for some validation without scripting.For Example:
When the Specified Account has any "Active" child Activity, the Activity flag should be true
Implementation without scripting:
Create a calculated field- Name: Check Activity
- Calculated = Y
- Calc Expression: BCHasRows("Account", "Action", '[Account Id] ="' + [Id] +'" AND [Type] = "Active"',"All")
This returns Y, if any child activity found.
Create a User property “On Field Update Set” to set the Activity Flag ; Value : “Check Activity”, “Activity Flag”
Syntax: BCHasRows ( BO , BC , search_expr, visibility)
Comments