Location/Name/Taxon (Hierarchies)
Values can be Location. Name, Organisation, Individual or Taxon. The user is presented with a box which enables the magnifying glass icon to be used to open the appropriate hierarchy so that a selection can be made.
<?xml version='1.0' ?>
<!-- Example
Report
XML Report by Mike Weideli of Littlefield
Consultancy
Version 1 14
May 2008
-->
<CustomReport title="Ex1
ExampleReport" menupath="Example reports"
description=""
>
<SQL>
SELECT Item_Name
FROM Location_Name
<Where
keytype="Default">
WHERE
<Condition field=
"Location_key" operator="equal" type="Location" entrycount="-1"
name="Location" />
</Where>
</SQL>
</CustomReport>
Field
Note that the field should be the key from the hierarchy.
Location = Location_Key
Taxon =
Taxon_List_Item_Key
Name/Organisation/Individual = Name_key
Operator
The operator can only be equal or not equal.
Using the entrycount attribute
If 1 (the default) then only a single instance of the parameter entry control is available. If greater than 1 the control is repeated the number of times specified. The user has to make an entry in all of them for the report to run. If it is -1 then the user can add as few as(minimum 1) or as many entries as they wish. If the value is not equal to 1 then the only valid operator is "equal" . In the above example the user will be able to select a number of Locations to be included in the report.
Using the userucksack attribute
This enables Rucksack to be used as a source of data for Taxa, Location, Organisations or Individuals. (not Biotopes or Documents).
<Condition field= "Location_key" operator="equal" type="Location" entrycount="-1" name="Location" userucksack="optional" />
The userucksack attribute can be set to "yes", "no" or "optional". The default is "no". When set to "optional" the user can choose either to use the selected Rucksack or can opt to enter individual values as above.
entrycount must be = -1
Note that when used with Taxon the Rucksack may contain Taxon_List_Item_keys which are not at species level. These will not automatically be expanded. If this is required then the XML report will have to expand the entries.