callback::application-track::getGeneralInfo::impl::album (private)

 callback::application-track::getGeneralInfo::impl::album

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

callback implementation

See Also:

• callback::application-track::getGeneralInfo::contract

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

Testcases:

No testcase defined.

Source code:

    ::callback::application-track::getGeneralInfo::contract__arg_parser {*}$args

    db_1row my_query {
        select  count(distinct p.pa_photo_id) as result
            from acs_objects ac,acs_objects ac2,acs_objects ac1,acs_objects ac3,dotlrn_communities_all d,pa_albums p1,pa_photos p
            where p1.pa_album_id = ac.object_id
            and ac.context_id = ac1.object_id
            and ac1.context_id = ac2.object_id
            and ac2.context_id = ac3.object_id
            and ac3.context_id = d.package_id
            and d.community_id = :comm_id
            and p1.pa_album_id IN
            (select distinct p2.pa_album_id
            from pa_albums p2,cr_revisions c,cr_revisions c2, cr_items c1
                    where p.pa_photo_id = c.revision_id
                    and c.item_id = c1.item_id
                    and c2.revision_id = p2.pa_album_id
                    and c2.item_id = c1.parent_id)    
    
    } 
    
    return "$result"

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

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