Topic: Filtering bat records
This is probably a question for Mike, but if anyone else has something to contribute I'm all ears.
We have an xml report which we use very extensively which is a very heavily modified version of the supplied samples in a polygon report. One of my users has requested a modification to this report & I can't quite see how to go about it.
At the moment the report features a dropdown allowing the user to select whether to return 1. all records or 2. Only records of notable taxa (as referenced by a Designation set containing things we consider to be notable designations).
I have been asked to add a third option, to only return records of any bat taxa.
My preferred way of doing this would be to create a user function which would return true or false for a given Taxon_List_item_key. I envisage something like
ufn_Taxon_Is_A_Bat(TLIK), returning true if the TLIK is somewhere below Chiroptera in the hierarchy (including Chiroptera itself).
My understanding of the taxon dictionary is not sufficient to allow me to compose the SQL for this one, so any help would be very useful. All I need is a Select statement which returns all TLIK downstream of chiroptera, I can do the rest.
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre