| |
129 |
129 |
where element_id = :element_id |
| |
130 |
130 |
</querytext> |
| |
131 |
131 |
</fullquery> |
| |
132 |
132 |
|
| |
133 |
133 |
<fullquery name="portal::configure_dispatch.hide_update"> |
| |
134 |
134 |
<querytext> |
| |
135 |
135 |
update portal_element_map |
| |
136 |
136 |
set state = 'hidden' |
| |
137 |
137 |
where element_id = :element_id |
| |
138 |
138 |
</querytext> |
| |
139 |
139 |
</fullquery> |
| |
140 |
140 |
|
| |
141 |
141 |
<fullquery name="portal::configure_dispatch.revert_theme_update"> |
| |
142 |
142 |
<querytext> |
| |
143 |
143 |
update portals |
| |
144 |
144 |
set theme_id = :theme_id |
| |
145 |
145 |
where portal_id = :portal_id |
| |
146 |
146 |
</querytext> |
| |
147 |
147 |
</fullquery> |
| |
148 |
148 |
|
| |
149 |
|
<fullquery name="portal::configure_dispatch.revert_max_page_id_select"> |
| |
150 |
|
<querytext> |
| |
151 |
|
select page_id |
| |
152 |
|
from portal_pages |
| |
153 |
|
where portal_id = :portal_id |
| |
154 |
|
order by sort_key desc |
| |
155 |
|
limit 1 |
| |
156 |
|
</querytext> |
| |
157 |
|
</fullquery> |
| |
158 |
|
|
| |
159 |
|
<fullquery name="portal::configure_dispatch.revert_min_page_id_select"> |
| |
160 |
|
<querytext> |
| |
161 |
|
select page_id |
| |
162 |
|
from portal_pages |
| |
163 |
|
where portal_id = :portal_id |
| |
164 |
|
order by sort_key |
| |
165 |
|
limit 1 |
| |
166 |
|
</querytext> |
| |
167 |
|
</fullquery> |
| |
168 |
|
|
| |
169 |
149 |
<fullquery name="portal::configure_dispatch.revert_move_elements_for_del"> |
| |
170 |
150 |
<querytext> |
| |
171 |
151 |
select element_id |
| |
172 |
152 |
from portal_element_map |
| |
173 |
153 |
where page_id = :page_id |
| |
174 |
154 |
</querytext> |
| |
175 |
155 |
</fullquery> |
| |
176 |
156 |
|
| |
177 |
157 |
<fullquery name="portal::configure_dispatch.revert_get_source_page_info"> |
| |
178 |
158 |
<querytext> |
| |
179 |
159 |
select pretty_name, |
| |
180 |
160 |
layout_id, |
| |
181 |
161 |
sort_key |
| |
182 |
162 |
from portal_pages |
| |
183 |
163 |
where page_id = :source_page_id |
| |
184 |
164 |
</querytext> |
| |
185 |
165 |
</fullquery> |
| |
186 |
166 |
|
| |
187 |
167 |
<fullquery name="portal::configure_dispatch.revert_get_target_page_id"> |
| |
188 |
168 |
<querytext> |
