Creating a derived keyword

A derived keyword will be used to execute the business rule.

  1. In the Keyword Manager, right-click the Derived Keywords node and select Add Derived Keyword.
  2. Specify a name in the Derived Keyword Name field.
    For this example use KW_SP.
  3. Specify a category name in the Category field.
    The category defines where this keyword will be found in the Template Editor. For this example specify Account.
  4. Select BusinessObjectCollection from the Data Type list.
    The derived keyword will return a collection of bills by executing the stored procedure.
  5. Specify the base keyword in the Base Keyword field.
    The base keyword is the first parameter for the rule that will be executed. This example uses the account key, so the keyword is KW_Hansen.Billing_Account_AccountKey.
  6. Click Add above the Rules grid.
  7. Search for the GetComponentCollectionFromStoredProcedure rule that you created previously.
  8. Select the rule to show its parameters in the Selected Rule Parameters grid.
  9. Specify these values for the rule’s parameters:
    entityKey: KW_Hansen.Billing_Account_AccountKey
    storedProcedureName: Specify the name of the stored procedure that you previously created. Note that the name is case sensitive.
    parameterName: For SQL Server specify @accountkey. For Oracle specify p_accountKey.
    moniker: Hansen.Billing.BillCollection
  10. Click Done.
  11. Click Save.