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” ...