bm_user_can_write_in_some_folder_p (public)

 bm_user_can_write_in_some_folder_p viewed_user_id

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

Returns "t" if there is a folder that the browsing user can write in, and "f' otherwise.

Parameters:

viewed_user_id

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

Testcases:

No testcase defined.

Source code:

    set browsing_user_id [ad_conn user_id]

    set n_of_write_folders [db_string write_in_folders "select count(*) from bm_bookmarks
                     where owner_id = :viewed_user_id
                     and folder_p = 't'
                     and acs_permission.permission_p(bookmark_id, :browsing_user_id, 'write') = 't'"]

    return [ad_decode $n_of_write_folders "0" "f" "t"]

Generic XQL file:

packages/bookmarks/tcl/bookmarks-procs.xql

PostgreSQL XQL file:

<fullquery name="bm_user_can_write_in_some_folder_p.write_in_folders">
    <querytext>
      select count(*) from bm_bookmarks
                     where owner_id = :viewed_user_id
                     and folder_p = 't'
                     and acs_permission__permission_p(bookmark_id, :browsing_user_id, 'write')
      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-procs-postgresql.xql

Oracle XQL file:

<fullquery name="bm_user_can_write_in_some_folder_p.write_in_folders">
    <querytext>
      select count(*) from bm_bookmarks
                     where owner_id = :viewed_user_id
                     and folder_p = 't'
                     and acs_permission.permission_p(bookmark_id, :browsing_user_id, 'write') = 't'
      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-procs-oracle.xql