System Administration
Page Business Rules H
Use this page to
- Create a Stored Procedure Business Rule
- Create an External Page Business Rule
- Create a WebApp Event Business Rule
- Create a WebApp Event (Private) Business Rule
To access this page:
- Select Admin >WebApps in the Navigation pane.
-
Click the Pages icon for a WEB APP NAME.
-
Click the Events icon for a page.
-
Click the Business Rules icon for an event.
Field |
Description |
PRIORITY |
Displays the number indicating the order in which the workflows will run. Business Rules that have Force Foreground Execution enabled will run first if the event is set to background. |
ACTIVE |
If checked, the workflow will be run. If unchecked, the workflow will not be run. |
PROCEDURE TYPE |
Displays the type of Business rule. Options are:
NOTE: Refer to Register Workflow Views for information about adding Business Rules to a workflow. |
DESCRIPTION |
Displays the name of the workflow view. |
COMMENT |
Displays comments entered by the user. |
RUN ON VALIDATE |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
RUN ON VALIDATE FAIL |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
FORCE FOREGROUND EXECUTION |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |
Page Business Rules V
Use this page to Register Workflow Views.
NOTE: The fields that display on this page depend on the Procedure Type selected on the Horizontal View. Procedure types are:
Procedure Type of Stored Procedure
Use this page to Create a Stored Procedure Business Rule.
NOTE: CranSoft attempts to wrap all procedures within a single SQL transaction. To avoid deadlocks, all pending transactions are committed before executing an external process. As a result, mixing external processes and SQL stored procedures can result in errors which cannot be completely rolled back. To minimize the effect, consider placing all external processes after SQL stored procedures by giving them a higher priority.
Field |
Description |
Business Rule Properties |
|
Procedure |
Displays the name of the SQL stored procedure. Click the link on the name to open the Definition page to view the SQL code. |
Comment |
Displays a user-entered comment, usually a description of what the stored procedure does. |
Advanced Properties |
|
Run On Validate |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
Run On Validate Fail |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
Force Foreground Execution |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |
Timeout |
Displays the amount of time in seconds that the stored procedure can run before a timeout error displays. |
Procedure Type of Workflow
Use this page to Register Workflow Views.
Field |
Description |
Business Rule Properties |
|
Alternate View |
Displays the name of the Alternative View. Using an alternate view will allow for a different set of data when the workflow is created at runtime. The view will still be restricted by the current record's primary keys. If multiple records are returned, then multiple workflows will be sent out. |
Workflow Fields |
Click to open the Advanced Workflow page to configure workflow fields that determine what displays in the subject line, body text, and other fields of the workflow. These fields must be added to the view and aliased correctly to be used in the workflow. Refer to Configure Workflow Fields for more information about configuring the workflow email sent with this workflow. NOTE: The Workflow Fields button is not accessible until Save is clicked. |
Message Type ID |
Displays the Message Type box that appears when the workflow is executed. Message Types are configured in System Admin > Configuration > Message Types. This configuration controls how the pop- up message displays for the user, including the color of the message box and the image that appears in it. For example, if the message contains as serious error, select a message type with red coloring and an error X as the icon. |
Comment |
Displays a user-entered comment about the workflow. |
Link Properties |
|
Workflow Links |
Click to open the Workflow Links page to create custom workflow links. Refer to Configure Workflow Links for more information. NOTE: The Workflow Links button is not accessible until Save is clicked. |
Link User ID |
The Link User ID used for anonymous users. This list box displays all Anonymous user accounts. Refer to the Workflow Views Overview for more information on creating an anonymous user account |
Link Expire Days |
Displays the number of days the workflow link is active and therefore accessible. |
Link Reuse |
If checked, the workflow link can be used multiple times until it expires. Otherwise, the user is denied access to the workflow link after one use. |
Link to Page ID |
Displays the page the page that opens when the user clicks the link. Options in this list box display as [Component Name : Page Name], for example, Collect : Copy Targets. |
Link to Page Restricted |
Restricts page access between two pages bound by key fields. Uncheck the check box to deactivate the option and allow a link from one page to another without restrictions. This property is used in conjunction with the Binding Field Names option. Normally when two pages contain shared key fields (such as Orders and Order Details), users will want to restrict the link to page by binding key. Turning this option off allows the user to link from one page to another without restriction. |
Binding Field Names |
Displays the binding fields that are required when the primary keys are not available or if the primary keys have different names. Binding field names are needed when the linking relationship cannot be inferred, because keys are either not defined or have different names from parent to child. Specify them here as one or more parent=child pairs, separated by commas. For example: CustomerID=CustID; or EmployeeID=EmployeeID, Department=DepartNo. In cases where the primary keys are not defined, but the names are identical between parent and child, the =child portion may be omitted. |
Advanced Properties |
|
Run On Validate |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
Run On Validate Fail |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
Force Foreground Execution |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |
Timeout |
Displays the amount of time in seconds that the stored procedure can run before a timeout error displays. |
Procedure Type of External Page
Use this page to Create an External Page Business Rule.
NOTE: CranSoft attempts to wrap all procedures within a single SQL transaction. To avoid deadlocks, all pending transactions are committed before executing an external process. As a result, mixing external processes and SQL stored procedures can result in errors which cannot be completely rolled back. To minimize the effect, consider placing all external processes after SQL stored procedures by giving them a higher priority.
Field |
Description |
Business Rule Properties |
|
Web App Plugin Type Code |
Displays the name of the plugin that executes when the event fires. |
Comment |
Displays a user entered comment about what the code does. |
Advanced Properties |
|
Run On Validate |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
Run On Validate Fail |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
Force Foreground Execution |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |
Procedure Type of WebApp Event
Use this page to Create a WebApp Event Business Rule.
Field |
Description |
Business Rule Properties |
|
Event Page ID |
Displays the name of the component and page name where the event associated with this Business rule runs. |
Event Name |
Displays the name of the event on the page associated with this Business rule. |
Parameter View |
Displays the name of an optional parameter view that can provide secondary data to pass to a shared event. This view contains columns that are available as extra columns to map to parameters to send to a shared event. This view will be executed as part of the shared event, pulling in an associated record to the executing record, and assigning the other column data to mapped parameters. This parameter view allows another view to provide more data to an event without putting all the columns in the horizontal or vertical view on the page. This view is not required. If the field is blank, and the public WebApp event requires parameters be passed in to execute the event, the parameters set on the Page Event Parameters page are used. |
Parameters |
Click to open the Page Event Rule Parameters page to add, edit and delete parameters that can be passed to this Business rule from a Public WebApp Event. |
Comment |
Displays a user-entered comment. |
Advanced Properties |
|
Run On Validate |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
Run On Validate Fail |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
Force Foreground Execution |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |
Procedure Type of WebApp Event (Private)
Use this page to Create a WebApp Event (Private) Business Rule.
Field |
Description |
Business Rule Properties |
|
Event Name |
Displays the name of the WebApp event. |
Comments |
|
Comment |
Displays a user-entered comment about the WebApp event. |
Advanced Properties |
|
Run On Validate |
If checked and the corresponding Validation rule returns zero records or if it returns records with a severity level less than Error, the Business rule executes. |
Run On Validate Fail |
If checked and the corresponding Validation rule returns any record that fails with a severity level of Error, the Business rule executes. |
Force Foreground Execution |
If checked and the workflow is on an event that is set to run in the background, it will execute twice, once in the foreground and later in the background. The intent of the feature is to ensure that the Business rule runs against the Web Server, even if the event is set to the background. For example, Force Foreground Execution may be required for plugin access to the Http Context. |