Page 1 of 1

Notes field query

Posted: Fri May 03, 2019 9:03 am
by AndyAmphlett
Tom,

It is possible to run a query looking for text within the Comments Field (= Notes in the DDb), eg. https://database.bsbi.org/search.php#re ... 64e5319678. That query was looking for records from vc96 where the road number 'A9' was in the Notes field. But this also finds any word that contains 'A9' eg. Quadrat A97, or (roads) A96, A938 etc. I thought using a space after 'A9 ie %A9 % would work but that omits records where there is a character after the '9' eg a full stop. Is there a way to restrict the query to only find exactly matching text / whole words? Not urgent, but would be quite useful.

Thanks,

Andy.

Re: Notes field query

Posted: Fri May 03, 2019 9:59 am
by admin
Hi Andy,

Good question. A working, but bodged solution would be to search for various alternative punctuation characters after A9 (including absence, to match at the end of a string). e.g.

Screenshot 2019-05-03 09.33.00.png
Screenshot 2019-05-03 09.33.00.png (18.85 KiB) Viewed 8815 times


https://database.bsbi.org/search.php#re ... e39cfc1cdb


It would be far better if proper matching using regular expressions was allow, rather than just simplistic wildcards. That wouldn't be difficult to add, but probably needs an explicit user-interface option to enable/disable - because many users wouldn't want to use a formal expressions for searching.

Re: Notes field query

Posted: Fri May 03, 2019 10:35 am
by AndyAmphlett
Tom,

Thanks. That is better. Still finds records with 'Quadrat A9.' and 'Quadrat NA9.' in the Notes field, but can investigate via a spreadsheet.

A better example that VCRs may find useful is to look for records where a var. name is included in the Notes field, eg. https://database.bsbi.org/search.php#re ... b0e66d39ea. This works pretty well, and detects a lot of examples where a var. name is not available in MapMate but is added to the Comments.

Andy.