attachments::toggle_approved (public)

 attachments::toggle_approved -object_id object_id -item_id item_id \
    [ -approved_p approved_p ]

Defined in packages/attachments/tcl/attachments-procs.tcl

toggle approved_p for attachment

Switches:

-object_id (required)

-item_id (required)

-approved_p (optional)

Testcases:

attachments_basic_api

Source code:

        db_dml toggle_approved_p {}

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="attachments::toggle_approved.toggle_approved_p">
    <querytext>
          update attachments set
             approved_p = coalesce(:approved_p, not approved_p)
            where object_id = :object_id
              and item_id = :item_id
        </querytext>
</fullquery>

packages/attachments/tcl/attachments-procs.xql