| |
1 |
|
<?xml version="1.0"?> |
| |
2 |
|
<queryset> |
| |
3 |
|
|
| |
4 |
|
<fullquery name="application_link::delete_links.linked_packages"> |
| |
5 |
|
<querytext> |
| |
6 |
|
select rel_id |
| |
7 |
|
from acs_rels |
| |
8 |
|
where rel_type = 'application_link' |
| |
9 |
|
and (object_id_one = :package_id |
| |
10 |
|
or object_id_two = :package_id) |
| |
11 |
|
</querytext> |
| |
12 |
|
</fullquery> |
| |
13 |
|
|
| |
14 |
|
<fullquery name="application_link::get.linked_packages"> |
| |
15 |
|
<querytext> |
| |
16 |
|
select object_id_two |
| |
17 |
|
from acs_rels |
| |
18 |
|
where object_id_one = :package_id |
| |
19 |
|
and rel_type = 'application_link' |
| |
20 |
|
</querytext> |
| |
21 |
|
</fullquery> |
| |
22 |
|
|
| |
23 |
|
<fullquery name="application_link::get_linked.linked_package"> |
| |
24 |
|
<querytext> |
| |
25 |
|
select p.package_id |
| |
26 |
|
from acs_rels r, apm_packages p |
| |
27 |
|
where r.object_id_one = :from_package_id |
| |
28 |
|
and r.object_id_two = p.package_id |
| |
29 |
|
and p.package_key = :to_package_key |
| |
30 |
|
and r.rel_type = 'application_link' |
| |
31 |
|
</querytext> |
| |
32 |
|
</fullquery> |
| |
33 |
|
|
| |
34 |
|
</queryset> |
