| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
3 |
3 |
<queryset> |
| |
4 |
4 |
|
| |
5 |
5 |
<fullquery name="dynamic_attributes"> |
| |
6 |
6 |
<querytext> |
| |
7 |
7 |
|
| |
8 |
8 |
select a.attribute_id, a.attribute_name, a.pretty_name, a.pretty_plural, |
| |
9 |
9 |
a.datatype, a.default_value |
| |
10 |
10 |
from acs_attributes a, dtype_attributes d |
| |
11 |
11 |
where a.attribute_id = d.attribute_id |
| |
12 |
12 |
and a.object_type = :object_type |
| |
13 |
13 |
order by a.sort_order |
| |
14 |
14 |
|
| |
15 |
15 |
</querytext> |
| |
16 |
16 |
</fullquery> |
| |
17 |
17 |
|
| |
18 |
|
<fullquery name="dynamic_forms"> |
| |
19 |
|
<querytext> |
| |
20 |
|
|
| |
21 |
|
select f.form_id, f.name as form_name, a.attribute_name, |
| |
22 |
|
e.widget, e.is_required |
| |
23 |
|
from dtype_forms f, dtype_form_elements e, acs_attributes a |
| |
24 |
|
where f.object_type = :object_type |
| |
25 |
|
and e.form_id = f.form_id |
| |
26 |
|
and a.attribute_id = e.attribute_id |
| |
27 |
|
|
| |
28 |
|
</querytext> |
| |
29 |
|
</fullquery> |
| |
30 |
|
|
| |
31 |
18 |
</queryset> |
