Creating a rule

  1. Select System > Agency Personalization > Keyword Manager.
  2. Select the Common node under Rules.
  3. Under Available Common Methods select this method:
    BusinessObjectCollection GetComponentCollectionFromStoredProcecdure( Integer entityKey, String storedProcedureName, String parameterName, String moniker )
  4. Click Create Rules.
Note: The Keyword Manager includes several other common rules that work with stored procedures.

These rules can be used to execute a stored procedure without returning any data:

  • BusinessObjectCollection ExecuteStoredProcecdure( Integer entityKey, String storedProcedureName, String parameterName )
  • BusinessObjectCollection ExecuteStoredProcecdure( String entityCode, String storedProcedureName, String parameterName )

These rules can be used to execute stored procedures and return data for components or component collections:

  • BusinessObject GetComponentFromStoredProcecdure( Integer entityKey, String storedProcedureName, String parameterName, String moniker )
  • BusinessObject GetComponentFromStoredProcecdure( String entityCode, String storedProcedureName, String parameterName, String moniker )
  • BusinessObjectCollection GetComponentCollectionFromStoredProcecdure( String entityCode, String storedProcedureName, String parameterName, String moniker )