OpenACS

nimam
committed
MAIN:nimam:20080207181503
on 07 Feb 08
Fixed some minor bugs
openacs-4/.../datamanager/www/manage-object.xql (+0 -1)
33 33          ao.object_id in (select content_id
34 34                            from static_portal_content
35 35                            where body <> '' and package_id=:community_id) and
36 36                                  spc.content_id=ao.object_id and
37 37                                  not (spc.pretty_name like '#dotlrn-static%_info_%#')
38 38    </querytext>
39 39 </fullquery>
40 40
41 41 <fullquery name="select_forum">
42 42   <querytext> 
43 43     SELECT fo.name as object_name,
44 44            ao.object_id,
45 45            us1.username as creation_user,
46 46            to_char(ao.creation_date,'YYYY-MM-DD HH:MM:SS') as creation_date,            
47 47            fo.charter,
48 48            fo.presentation_type,
49 49            fo.posting_policy,
50 50            fo.enabled_p,
51 51            fo.thread_count,
52 52            fo.approved_thread_count,
53              fo.forums_forums,
54 53            fo.last_post,
55 54            fo.autosubscribe_p
56 55     FROM  acs_objects as ao,
57 56           users as us1,
58 57           forums_forums as fo   
59 58     WHERE
60 59           us1.user_id = ao.creation_user
61 60           and fo.forum_id = ao.object_id
62 61           and ao.context_id in (select package_id
63 62                                 from dotlrn_community_applets as dca,
64 63                                      dotlrn_applets as da 
65 64                                 where dca.applet_id=da.applet_id and
66 65                                       da.applet_key='dotlrn_forums' and
67 66                                       dca.community_id = :community_id)
68 67      ORDER BY object_name, ao.creation_date
69 68    </querytext>
70 69 </fullquery>
71 70
72 71 <fullquery name="select_new">
73 72     <querytext>