1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
<div id='sql_function'>
<h2>Edit the SQL function <span name='name'/></h2>
<table class='multiFormTable' cellpadding="0" cellspacing="0" border="0" id='reporting_function'>
<tr>
<td>
<h3>Sql Query:</h3> The defining SQL for this function. You refer to reported fields as `reportform+field`
</td>
<td>
<textarea cols='53' rows='4' name='qry' class='validate=[nonempty]'></textarea>
</td>
</tr>
<tr>
<td>
<h3>Description:</h3> A description of this function to be displayed to the end user
</td>
<td>
<textarea type='text' name='description' rows='4' cols='53'></textarea>
</td>
</tr>
<tr>
<td colspan='2'>
<h3>Form Field:</h3> Select the form field that this function takes values in
<select name='formfield' >
</select>
</td>
</tr>
<tr>
<td>
<h3>Selectable Forms</h3>The forms which are selectable for this field. Only applies if
the form field is a subclass of I2CE_FormField_MAPPED. In which case it should be
a comma seperated list of forms. If not set, it defaults to the name of this function.
</td>
<td>
<input name='select_forms'/>
</td>
</tr>
<tr>
<td>
<h3>Linked Fields</h3>The fields that are linked when listing options.
Only applies if the form field is a subclass of I2CE_FormField_MAPPED.
It should be a colon separated list of 'forms' or 'form+linkfield's.
Example: "county:district+region:[region]:country".
If not set, it defaults to the name of this function.
</td>
<td>
<input name='link_fields'/>
</td>
</tr>
</table>
</div>
|