Update, Feb 2015: AlphaFlow on plone has been replaced by a home-grown postgres/django application called "wf", which runs on host And there was much rejoicing.

So as of Feb 2015, this redmine project will also contain documentation on the "wf" suite.

There is the oracle part (pl/sql and accompanying javascript for web viewing):
- work_flow_ora (

The oracle part is really 3 separate logical components:
1) Persistence of signature history. Who signed what, when; persisted for all time in our master MISCOMP database.
2) Person-in-role calculation (wf_role_lib). For certain Well-Known Roles (org-chart derived and/or system administrative roles), calculate who is in the role (and who else would be authorized to "put on the hat").
3) Proxy/hats. "Who may I be proxy for?" "Who may be proxy for me?" "Who is proxying for me?" "Put on the hat." "Take off the hat".

There are python "wrapper" scripts that provide python access to the Oracle packages:
- work_flow_api (
- alpha_flow_api (

And there is the "wf" electronic signature engine that provides the signing interface for any app that chooses to use it (currently only MISER and LEAVE_REQUEST):

There are two existing applications using the wf engine; the work_flow definitions for these two applications are:
- miser (
- leave_request (

Overview: An application has "items" that need to be signed. The application should:
a) define a WORK_FLOW (state machine, stored in the wf_db; see the miser_wf_def or leave_request_wf_def for example python code; uses the wf_def_loader utility to make it easier to load the work_flow definition into the wf db and make sure it follows all rules, etc.). [NB: no public interfaces for this within the WF application, anybody choosing to use the new WF engine will need to work directly with developers in order to load a new workflow definition into the database].
b) define a callback URL that can be used by the oracle WORK_FLOW code to retrieve the persons-in-roles for each work_flow_item. (The application is free to call the WORK_FLOW.WF_ROLE_LIB functions if needed to calculate WHO is in each role, but the application itself must know which roles are required).
c) define a VIEW url that can be used to VIEW the wf_item from the wf site when it is being signed (what the signer sees when signing the item)
d) OPTIONAL: define a callback URL that should be called when an item is signed as it moves through the work_flow.

A WF admin/developer will load the workflow state machine into the WF database.

An Oracle admin/developer will update the WORK_FLOW data so that Oracle knows when to call the new workflow state machine (start at and go to the WORK_FLOWS link (right-hand side)).

Useful URLs to know about:
- Oracle Open WF Item report (what MISCOMP thinks is open):
- WF open WF Item report (what the WF engine thinks it is working on):
- Oracle WF utilities:

Issue tracking

open closed Total
Bug 0 0 0
Feature 0 0 0
Support 0 0 0
Idea 0 0 0

View all issues | Calendar | Gantt

Spent time

0.00 hour

Details | Report

Latest news

AlphaFlow on plone is dead. (1 comment)
New "wf" application replaces alphaflow on plone.
Added by Lauri Carpenter over 3 years ago

Release work_flow_ora v3_20 (2 comments)
work_flow_ora v3_20. Scheduled for 2010-Jun-29 08:30.
Added by James Fromm almost 8 years ago

View all news