workflow::deputy::edit (public)

 workflow::deputy::edit -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

Edit deputy information for a certain user_id and deputy_id.

Switches:

-user_id (required)

-deputy_id (required)

-start_day (required)

-end_day (required)

-message (required)

Author:

Peter Marklund

See Also:

• workflow::deputy::new

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

Testcases:

No testcase defined.

Source code:

    db_dml update_deputy {}

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="workflow::deputy::edit.update_deputy">
    <querytext>
	update workflow_deputies
	    set start_date = to_date(:start_day, 'YYYY-MM-DD'), 
	        end_date = to_date(:end_day, 'YYYY-MM-DD'),
	        message = :message
	where user_id = :user_id
	  and deputy_user_id = :deputy_id
    </querytext>
</fullquery>

packages/workflow/tcl/deputy-procs.xql