| |
5 |
5 |
|
| |
6 |
6 |
<fullquery name="lars_blog__rss_datasource.now"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
select to_char(sysdate,'DD Mon YYYY hh12:MI am') from dual |
| |
9 |
9 |
</querytext> |
| |
10 |
10 |
</fullquery> |
| |
11 |
11 |
|
| |
12 |
12 |
<fullquery name="lars_blog__rss_datasource.blog_rss_items"> |
| |
13 |
13 |
<querytext> |
| |
14 |
14 |
select * |
| |
15 |
15 |
from (select entry_id, |
| |
16 |
16 |
e.title, |
| |
17 |
17 |
e.content, |
| |
18 |
18 |
to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, |
| |
19 |
19 |
c.name as category |
| |
20 |
20 |
from pinds_blog_entries e, |
| |
21 |
21 |
pinds_blog_categories c |
| |
22 |
22 |
where e.package_id = :package_id |
| |
23 |
23 |
and e.draft_p = 'f' |
| |
24 |
24 |
and e.deleted_p = 'f' |
| |
25 |
|
and c.category_id = e.category_id (+) |
| |
|
25 |
and c.category_id (+) = e.category_id |
| |
26 |
26 |
order by e.entry_date desc) |
| |
27 |
27 |
where rownum < 11 |
| |
28 |
28 |
</querytext> |
| |
29 |
29 |
</fullquery> |
| |
30 |
30 |
|
| |
31 |
31 |
<fullquery name="lars_blog__rss_datasource.user_blog_rss_items"> |
| |
32 |
32 |
<querytext> |
| |
33 |
33 |
select * |
| |
34 |
34 |
from (select e.entry_id, |
| |
35 |
35 |
e.title, |
| |
36 |
36 |
e.content, |
| |
37 |
37 |
to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, |
| |
38 |
38 |
c.name as category |
| |
39 |
39 |
from pinds_blog_entries e, |
| |
40 |
40 |
acs_objects o, |
| |
41 |
41 |
users u, |
| |
42 |
42 |
pinds_blog_categories c |
| |
43 |
43 |
where e.package_id = :package_id |
| |
44 |
44 |
and o.object_id = e.entry_id |
| |
45 |
45 |
and o.creation_user = :user_id |
