| |
55 |
55 |
<fullquery name="ams::list::exists_p.list_exists_p"> |
| |
56 |
56 |
<querytext> |
| |
57 |
57 |
select '1' |
| |
58 |
58 |
from ams_lists |
| |
59 |
59 |
where package_key = :package_key |
| |
60 |
60 |
and object_type = :object_type |
| |
61 |
61 |
and list_name = :list_name |
| |
62 |
62 |
</querytext> |
| |
63 |
63 |
</fullquery> |
| |
64 |
64 |
|
| |
65 |
65 |
<fullquery name="ams::list::get_list_id_not_cached.get_list_id"> |
| |
66 |
66 |
<querytext> |
| |
67 |
67 |
select list_id |
| |
68 |
68 |
from ams_lists |
| |
69 |
69 |
where package_key = :package_key |
| |
70 |
70 |
and object_type = :object_type |
| |
71 |
71 |
and list_name = :list_name |
| |
72 |
72 |
</querytext> |
| |
73 |
73 |
</fullquery> |
| |
74 |
74 |
|
| |
|
75 |
<fullquery name="ams::list::attribute::map.delete_old_entry"> |
| |
|
76 |
<querytext> |
| |
|
77 |
delete from ams_list_attribute_map |
| |
|
78 |
where list_id = :list_id |
| |
|
79 |
and ( attribute_id = :attribute_id or sort_order = :sort_order ) |
| |
|
80 |
</querytext> |
| |
|
81 |
</fullquery> |
| |
75 |
82 |
|
| |
76 |
83 |
<fullquery name="ams::list::attribute::map.ams_list_attribute_map"> |
| |
77 |
84 |
<querytext> |
| |
78 |
85 |
select ams_list__attribute_map ( |
| |
79 |
86 |
:list_id, |
| |
80 |
87 |
:attribute_id, |
| |
81 |
88 |
:sort_order, |
| |
82 |
89 |
:required_p, |
| |
83 |
90 |
:section_heading |
| |
84 |
91 |
) |
| |
85 |
92 |
</querytext> |
| |
86 |
93 |
</fullquery> |
| |
87 |
94 |
|
| |
88 |
95 |
<fullquery name="ams::list::attribute::map.get_highest_sort_order"> |
| |
89 |
96 |
<querytext> |
| |
90 |
97 |
select sort_order |
| |
91 |
98 |
from ams_list_attribute_map |
| |
92 |
99 |
where list_id = :list_id |
| |
93 |
100 |
order by sort_order desc |
| |
94 |
101 |
limit 1 |
