| |
159 |
159 |
</fullquery> |
| |
160 |
160 |
|
| |
161 |
161 |
<fullquery name="portal::swap_element.get_next_sort_key"> |
| |
162 |
162 |
<querytext> |
| |
163 |
163 |
select sort_key as other_sort_key, |
| |
164 |
164 |
element_id as other_element_id |
| |
165 |
165 |
from (select pem.sort_key, |
| |
166 |
166 |
element_id |
| |
167 |
167 |
from portal_element_map pem, portal_pages pp |
| |
168 |
168 |
where pp.portal_id = :portal_id |
| |
169 |
169 |
and pem.page_id = :my_page_id |
| |
170 |
170 |
and pem.page_id = pp.page_id |
| |
171 |
171 |
and region = :region |
| |
172 |
172 |
and pem.sort_key > :my_sort_key |
| |
173 |
173 |
and state != 'pinned' |
| |
174 |
174 |
order by pem.sort_key) |
| |
175 |
175 |
where rownum = 1 |
| |
176 |
176 |
</querytext> |
| |
177 |
177 |
</fullquery> |
| |
178 |
178 |
|
| |
|
179 |
<fullquery name="portal::configure_dispatch.revert_max_page_id_select"> |
| |
|
180 |
<querytext> |
| |
|
181 |
select * |
| |
|
182 |
from (select page_id |
| |
|
183 |
from portal_pages |
| |
|
184 |
where portal_id = :portal_id |
| |
|
185 |
order by sort_key desc) |
| |
|
186 |
where rownum = 1 |
| |
|
187 |
</querytext> |
| |
|
188 |
</fullquery> |
| |
|
189 |
|
| |
|
190 |
<fullquery name="portal::configure_dispatch.revert_min_page_id_select"> |
| |
|
191 |
<querytext> |
| |
|
192 |
select * |
| |
|
193 |
from (select page_id |
| |
|
194 |
from portal_pages |
| |
|
195 |
where portal_id = :portal_id |
| |
|
196 |
order by sort_key) |
| |
|
197 |
where rownum = 1 |
| |
|
198 |
</querytext> |
| |
|
199 |
</fullquery> |
| |
|
200 |
|
| |
179 |
201 |
</queryset> |
