1 Reply by Kirsty Gamble

  • Kirsty Gamble
  • Member
  • Offline
  • From: LRERC
  • Registered: 30-05-2008
  • Posts: 24

Re: ‘Missing’ Filter options from the Survey screen

On our ‘new’ installation of Recorder we appear to be missing some options for filtering.  When selecting an observation from the survey screen, there is no option to filter on ‘surveyor’s reference’.  This is present on our ‘old’ installation of Recorder.

This is extremely useful to us and obviously saves time when searching.  – Does anyone know how to get this option?  Could it be a problem with our installation or are these filters something that we can add to?

Any help would be gratefully appreciated!
Many thanks

Kirsty
(Leicestershire and Rutland Environmental Records Centre)

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: ‘Missing’ Filter options from the Survey screen

It looks as though your old installation was modified to include Surveyor’s Ref as something you could filter on when filtering species observations. To include it in your new system you will need to run the following queries on NBNData in Management Studio:

Update USABLE_FIELD Set APPLY_TO = 'F' Where TABLE_NAME = 'TAXON_OCCURRENCE' and FIELD_NAME = 'SURVEYORS_REF'

Update USABLE_FIELD Set CALCULATION_SQL =
'SELECT TXO.Taxon_Occurrence_Key AS ItemKey FROM Taxon_Occurrence TXO WHERE TXO.SURVEYORS_REF'
Where TABLE_NAME = 'TAXON_OCCURRENCE' and FIELD_NAME = 'SURVEYORS_REF'

This worked when I tested it but please test it on your installation. If you and any other users who would like to test it are happy with it we can consider making it a standard feature of Recorder 6.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687