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

Popular posts from this blog

Refresh Siebel Applet not Buscomp - "RefreshBusComp" Alternative

Drill down in siebel form applet