SQL smart folder date-based not working?

A place for users to ask each other questions, make suggestions, and discuss Bookends.
Post Reply
GJPhD
Posts: 41
Joined: Fri Mar 10, 2017 10:30 am

SQL smart folder date-based not working?

Post by GJPhD »

I updated to 14.0.9 yesterday and the SQL Smart Folders that are date based (i.e. added or edited last two weeks) are no longer populated, even though I added various PDFs to the library and edited various publications.

I could verify tomorrow in the office if this is also the case for 14.0.8, but I was just wondering if this is a bug introduced with 14.0.9?
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL smart folder date-based not working?

Post by Jon »

Nothing has changed in 14.0.9 in this regard. Please Rebuild your library and see if that helps.

Jon
Sonny Software
GJPhD
Posts: 41
Joined: Fri Mar 10, 2017 10:30 am

Re: SQL smart folder date-based not working?

Post by GJPhD »

I rebuild, verified and all that, but no change. I can also confirm that it happens under 14.0.8 with my library.

I can get the SQL 'last 15 references added' to work and view the latest added articles, so unsure what is causing the problem
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL smart folder date-based not working?

Post by Jon »

Did you edit the smart SQL group? Post the actual SQL in the group that's not working.

Jon
Sonny Software
GJPhD
Posts: 41
Joined: Fri Mar 10, 2017 10:30 am

Re: SQL smart folder date-based not working?

Post by GJPhD »

These standard SQL do not work
dateModified > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (14 * 24 * 60 * 60)
dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (14 * 24 * 60 * 60)
I edited one of these into this for myself (For added last day..) that also does not work
dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) - (1 * 24 * 60 * 60)
This SQL - however - does work
recID <> 0 order by dateAdded DESC limit 30
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL smart folder date-based not working?

Post by Jon »

The first two work for me. Please do a Repair and then a Rebuild on your library in case there is an issue with it.

Jon
Sonny Software
GJPhD
Posts: 41
Joined: Fri Mar 10, 2017 10:30 am

Re: SQL smart folder date-based not working?

Post by GJPhD »

I tried those, but they don't work to solve the problem..
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL smart folder date-based not working?

Post by Jon »

Please try with a fresh new library.

And zip and send your library to support@sonnysoftware.com

Jon
Sonny Software
GJPhD
Posts: 41
Joined: Fri Mar 10, 2017 10:30 am

Re: SQL smart folder date-based not working?

Post by GJPhD »

Creating a fresh library and adding several articles returned the same problem for the smart groups.

You got mail (in a few moments), thanks for helping out.
Sandro
Posts: 2
Joined: Sat Feb 01, 2014 8:49 am

Re: SQL smart folder date-based not working?

Post by Sandro »

same problem with me
i die repair and rebuild library
and have sent my library to you as well some time ago
still does not work the same sql
Jon
Site Admin
Posts: 10048
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: SQL smart folder date-based not working?

Post by Jon »

What version of Bookends?

Jon
Sonny Software
Post Reply