| |
184 |
184 |
and aa.object_id = b.bug_id |
| |
185 |
185 |
group by p.first_names, p.last_name, crum.user_id |
| |
186 |
186 |
</querytext> |
| |
187 |
187 |
</fullquery> |
| |
188 |
188 |
|
| |
189 |
189 |
|
| |
190 |
190 |
<fullquery name="bug_tracker::assignee_get_options.assignees"> |
| |
191 |
191 |
<querytext> |
| |
192 |
192 |
select acs_object__name(p.party_id) || ' (' || p.email || ')' as label, |
| |
193 |
193 |
party_id from parties p |
| |
194 |
194 |
where party_id in (select distinct(party_id) from workflow_case_role_party_map, |
| |
195 |
195 |
workflow_cases |
| |
196 |
196 |
where workflow_case_role_party_map.case_id = workflow_cases.case_id |
| |
197 |
197 |
and workflow_cases.workflow_id = :workflow_id) |
| |
198 |
198 |
</querytext> |
| |
199 |
199 |
</fullquery> |
| |
200 |
200 |
|
| |
201 |
201 |
<fullquery name="bug_tracker::project_new.instance_info"> |
| |
202 |
202 |
<querytext> |
| |
203 |
203 |
select p.instance_name, o.creation_user, o.creation_ip |
| |
204 |
|
from apm_packages p join acs_objects o on (p.package_id = o.object_id) w |
| |
205 |
|
here p.package_id = :project_id |
| |
|
204 |
from apm_packages p join acs_objects o on (p.package_id = o.object_id) |
| |
|
205 |
where p.package_id = :project_id |
| |
206 |
206 |
</querytext> |
| |
207 |
207 |
</fullquery> |
| |
208 |
208 |
|
| |
209 |
209 |
</queryset> |
