pa_all_photos_in_album_internal (private)

 pa_all_photos_in_album_internal album_id

Defined in packages/photo-album/tcl/photo-album-procs.tcl

queries and returns a list of all photo_ids in album_id in ascending order

Parameters:

album_id (required)

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

Testcases:

No testcase defined.

Source code:

    return [db_list get_photo_ids {}]

Generic XQL file:

<fullquery name="pa_all_photos_in_album_internal.get_photo_ids">
    <querytext>
      select 
  ci.item_id
from cr_items ci,
  cr_child_rels ccr
where ci.latest_revision is not null
  and ci.content_type = 'pa_photo'
  and ccr.parent_id = :album_id
  and ci.item_id = ccr.child_id
order by ccr.order_n
      </querytext>
</fullquery>

packages/photo-album/tcl/photo-album-procs.xql

PostgreSQL XQL file:

packages/photo-album/tcl/photo-album-procs-postgresql.xql

Oracle XQL file:

packages/photo-album/tcl/photo-album-procs-oracle.xql