| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
3 |
3 |
<queryset> |
| |
4 |
4 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
5 |
5 |
|
| |
6 |
6 |
<fullquery name="revision_info_select"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
|
| |
9 |
9 |
select da.repository_id as repository_id, |
| |
10 |
10 |
da.archive_name, |
| |
11 |
11 |
da.summary, |
| |
12 |
12 |
dar.revision_id, |
| |
13 |
13 |
dar.file_name, |
| |
14 |
14 |
dar.version_name, |
| |
15 |
|
dbms_lob.getlength(dar.content) as file_size, |
| |
|
15 |
round(dbms_lob.getlength(dar.content)/1024) as file_size, |
| |
16 |
16 |
case when da.latest_revision = dar.revision_id then 't' else 'f' end as current_version_p, |
| |
17 |
17 |
dar.creation_user, |
| |
18 |
18 |
dar.creation_date, |
| |
19 |
19 |
u.last_name || ', ' || u.first_names as creation_user_name |
| |
20 |
20 |
from download_archives_obj da, |
| |
21 |
21 |
download_arch_revisions_obj dar, |
| |
22 |
22 |
cc_users u |
| |
23 |
23 |
where da.archive_id = dar.archive_id and |
| |
24 |
24 |
dar.revision_id = :revision_id and |
| |
25 |
25 |
u.user_id = dar.creation_user |
| |
26 |
26 |
|
| |
27 |
27 |
</querytext> |
| |
28 |
28 |
</fullquery> |
| |
29 |
29 |
|
| |
30 |
30 |
|
| |
31 |
31 |
</queryset> |
