Sunday, September 15, 2019

The World's Premier Listing Software
for Birders and Naturalists!

Celebrating 24 Years Serving Birders
and Naturalists around the World!

FAQ - Current Support Issues Everyone Should Know About

Search this Site and the Forum Contents

Birder's Diary Forums

Query language for comments
Last Post 09/03/2019 9:59 AM by davidshuford. 2 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
Author Messages
davidshuford
Great Gray Owl
Great Gray Owl
Posts:251


--
08/29/2019 11:46 AM
  • Quote
  • Reply

Is there way to enter selection criteria in the Comments field? You can enter "x" for example and find all records with x, but that seems to be about it. I tried %%x%% and that did not work. I tried "x" AND "y", but that did not work.

Jeff Jones
Great Gray Owl
Great Gray Owl
Posts:8002


--
08/30/2019 9:36 AM
  • Quote
  • Reply

Hi David,

Good question. This was discussed many years ago in these forums somewhere, but I am unable to find it now. Probably in the previously corrupted version of the TechSupport forum.

What you enter into the Comments field in the View Sightings Setup window is put into an SQL query with a LIKE clause. For example, if you put "x" into the comments field, the SQL built and run looks like

Comments LIKE '*x*'

* = Any zero or more characters

So, any-or-no characters followed by "x" followed by any-or-no characters.

With that said, MSAccess (the Birder's Diary database engine) can use the rather limited syntax found here with the LIKE predicate. Would be nice if it supported full REGEX functionality, but it does not.

As an example, you can search for any numerical digit preceded by "x" by entering this into the search: "x[0-9]" or "x#". 

Note: remember that BD puts an asterisk on the front and end of whatever you enter into the search field for Comments.

Let me know if I can assist further with any questions on this.

Jeff

Birder's Diary Technical Support
davidshuford
Great Gray Owl
Great Gray Owl
Posts:251


--
09/03/2019 9:59 AM
  • Quote
  • Reply

Thank you for the information. I'll try it out.

Add Reply


Quick Reply
toggle
  Username:
Subject:
Body:
Security Code:
CAPTCHA image
Enter the code shown above in the box below

Support Tools

 TitleOwnerCategoryModified DateSize 
GreenShot - Advanced Screen Capture ToolJeff Jones 12/18/2013UnknownDownload
Screen Capture ToolJeff Jones 3/8/2016UnknownDownload