Workflow Framework Customizations: Data Location, Check for Task Authorizations, Task Locking

The Workflow framework has to capability of locking tasks to ensure that a task is only accessed by one user at a time.

Data Location

By default, the framework saves workflow data to a local SQLite workflowdata.db database. You can, however, configure the system to save workflow data to a different storage location by performing the following steps:

1. In the Project pane of the Designer select your project.
2. Click the Modify button in the viewer pane.
3. Click the Framework tab and scroll down to the Worfklow: data location setting.
   
    
    
4. If you want to store data in a different SQLite database enter the name of that database. If you want to store the data in ODBC-linked database enter the the name of an ODBC connection string; for example, "odbc:DSN=MY_DATA". In this example MY_DATA is the ODBC connection to an external database.
5. To change the names of the workflow tables you can use the "settings.cfg" file.
   
    

 Note: The tables in external databases must match the following table definitions.

Task Locking

To switch on or off task locking perform the following actions:

1. In the Project pane of the Designer select your project.
2. Click the Modify button in the viewer pane.
3. Click the Framework tab and scroll down to the appropriate setting.
4. Click the checkbox next to this setting.
   
    

Task Authorizations

By adding role tags to tasks you can specify that the framework checks whether a user has the role required to open a task. First, you specify roles in your model and then in the configuration settings you specify if the system checks for user roles. To configure a task authorization check perform the following actions:

1. In the Project pane of the Designer select your project.
2. Click the Modify button in the viewer pane.
3. Click the Framework tab and scroll down to the Worfklow: enable check for task authorizations setting.
4. Click the checkbox next to this setting.