workflow::deputy::new (public)

 workflow::deputy::new [ -user_id user_id ] -deputy_id deputy_id \
    -start_day start_day -end_day end_day [ -message message ]

Defined in packages/workflow/tcl/deputy-procs.tcl

Create a new deputizing period for a user during which workflow tasks will be assigned to a deputee.

Switches:

-user_id (optional)

The id of the user that is deputizing

-deputy_id (required)

The id of the user to deputize to

-start_day (required)

The start date of the deputizing period. Must be on ANSI format "YYYY-MM-DD"

-end_day (required)

The end date of the deputizing period. Must be on ANSI format "YYYY-MM-DD"

-message (optional)

Any message describing the deputizing

Author:

Peter Marklund

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    if { $user_id eq "" } {
    set user_id [ad_conn user_id]
    }

    db_dml insert_deputy {}

    # Flush the role assignment info for all cases
    # to make sure cache is in sync with db
    # Do we also need to flush the workflow level cache here?
    workflow::case::flush_cache

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="workflow::deputy::new.insert_deputy">
    <querytext>
	insert into workflow_deputies
		(user_id, deputy_user_id, start_date, end_date, message)
	values (:user_id, :deputy_id, to_date(:start_day, 'YYYY-MM-DD'), to_date(:end_day, 'YYYY-MM-DD'), :message)
    </querytext>
</fullquery>

packages/workflow/tcl/deputy-procs.xql