Cinnamon Hummingbird

Welcome to the Birder's Diary Forum for Support And General Questions

Use the Support forum for all questions or issues.
Use the Wish List forum to leave your ideas for improving Birder’s Diary.
Use the Community Sharing forum for sharing Photos, Trips, Stories, etc.
Setup your Forum photo and profile here.

Life List with Most...
 
Notifications
Clear all

[Solved] Life List with Most Recent Sightings

4 Posts
2 Users
0 Likes
452 Views
Posts: 5
Topic starter
(@russells)
Active Member
Joined: 2 years ago

I'm using version 5.1, and it does everything I need except one thing.  Life List reports show first sightings.  I'd like the option of showing most recent sightings of each species for the given parameters, e.g. location.  Do newer versions already do this?

Reply
3 Replies
Jeff
Posts: 954
 Jeff
Admin
(@jeff)
Creator & Technical Support
Joined: 4 years ago

Hi Russell,

I don't believe we have that specific functionality in BD. However, you are not the first to ask this question and there is a way to get that information from BD using an undocumented feature in BD.

Can you tell me, so that I can prioritize the inclusion of such a feature into BD at some point, how you use this information? Why is it important? What is its significance? That would be very helpful to me and also allow me to see new ways to implement it and use it.

The undocumented feature is available in BD (I think it is in v5.1, but don't hold me to that) and it involves writing SQL queries against the underlying BD database. This feature allows user access to all the data in any way.

image

Of course, it helps if you know SQL. The query above will produce the report you are asking for and sort the list in taxonomic order. You can also sort the list by most recent date/time by changing the last line to "Order by 2 Desc".

You get this undocumented feature by:

  1. Right-click on your BD desktop icon and choose Properties...
  2. In the Target field on the Shortcut Tab, 
  3. Add " /SQL" to the end of the current value. Outside of the double-quotes around the filename.
    image
  4. Click the OK button
  5. Exit and Restart BD
  6. Use Ctrl+Q to open the new SQL window.

Use of this window is not supported. But, if you copy and paste this text into the window and click the Execute button, you will get your data. And you can Export that data to Excel. 

Edit the parts with my name to match your observer's name and the taxonomy to match the one you are using.

Select First(CommonName) As Name, Max(DateAndtime) As LastSeen
From
((Sightings s inner join Classifications c on s.ThingID=c.Thingid)
inner join CommonNames cn on c.commonnameid=cn.commonnameid)
where c.taxonomyid = (select top 1 taxonomyid from taxonomylist where name like '*clement*' order by taxonomyid desc)
And s.ObserverID = (select observerid from observers where firstname='jeff' and lastname='jones')
Group By GenusID, SpeciesID
Order by 2 Desc

The reason it is unsupported is not because it has problems or it doesn't work. It is because SQL is a database programming language and I could spend the rest of my days answer How-To questions on using this. I don't mind giving you answers to questions like this, within limits.

Let me know. 

Reply
Posts: 5
Topic starter
(@russells)
Active Member
Joined: 2 years ago

Hi Jeff,

My wife and I often want to know, when we go to a birding location, when was the last time we saw certain birds there.  We want to know if a bird is a year lister, a decade lister, a century lister, etc.  Adding birds to any list is fun.

I'm familiar with SQL.

Thank you.  We love Birder's Diary.

Russell

Reply
Jeff
Posts: 954
 Jeff
Admin
(@jeff)
Creator & Technical Support
Joined: 4 years ago

Ok. Thanks Russell. 

Were you able to follow the instructions I provided for the undocumented SQL feature in BD?

Reply
Share: