| |
17 |
17 |
-fs_objects.sort_key as sort_key_desc, |
| |
18 |
18 |
fs_objects.file_upload_name, |
| |
19 |
19 |
fs_objects.title, |
| |
20 |
20 |
case |
| |
21 |
21 |
when :folder_path is null |
| |
22 |
22 |
then fs_objects.file_upload_name |
| |
23 |
23 |
else :folder_path || '/' || fs_objects.file_upload_name |
| |
24 |
24 |
end as file_url, |
| |
25 |
25 |
case |
| |
26 |
26 |
when fs_objects.last_modified >= (sysdate - :n_past_days) |
| |
27 |
27 |
then 1 |
| |
28 |
28 |
else 0 |
| |
29 |
29 |
end as new_p |
| |
30 |
30 |
from fs_objects |
| |
31 |
31 |
where fs_objects.parent_id = :folder_id |
| |
32 |
32 |
and exists (select 1 |
| |
33 |
33 |
from acs_object_party_privilege_map m |
| |
34 |
34 |
where m.object_id = fs_objects.object_id |
| |
35 |
35 |
and m.party_id = :viewing_user_id |
| |
36 |
36 |
and m.privilege = 'read') |
| |
37 |
|
order by fs_objects.sort_key, fs_objects.name |
| |
|
37 |
$orderby |
| |
38 |
38 |
|
| |
39 |
39 |
</querytext> |
| |
40 |
40 |
</fullquery> |
| |
41 |
41 |
|
| |
42 |
42 |
<fullquery name="get_folder_path"> |
| |
43 |
43 |
<querytext> |
| |
44 |
44 |
declare begin |
| |
45 |
45 |
:1 := content_item.get_path(:folder_id, :root_folder_id); |
| |
46 |
46 |
end; |
| |
47 |
47 |
</querytext> |
| |
48 |
48 |
</fullquery> |
| |
49 |
49 |
|
| |
50 |
50 |
</queryset> |
