Siebel Community

Welcome to Siebel Community. In this place you can find all the topics related to Siebel. This place is dedicated to provide information about how to implement Siebel CRM application. Siebel Technical/Functional consultants can get information from basics of Siebel CRM to advanced topics like EAI, EIM, eScripting, Workflows, Assignment Manager, Actuate Reports, Territory Management. This place also included Forums and Blogs to help you further.

Wednesday, February 1, 2012

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: Check Activity
Calc Expression: BCHasRows("Account", "Action", '[Account Id] ="' + [Id] +'" AND [Type] = "Active"',"All")
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)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)