View Single Post
Old 08-19-2022, 12:01 AM   #303
applegaa
Connoisseur
applegaa has learned how to buy an e-book online
 
applegaa's Avatar
 
Posts: 71
Karma: 76
Join Date: Apr 2019
Device: none
In my calibre library, I have two columns I use in "Lookup/Search Name [1]". They are #lastupdated and #lastread. #lastupdated is populated by FanFicFare using metadata pulled from the web site (usually RoyalRoad or ScribbleHub). #lastread is set by me manually in Calibre. My first search criteria is that #lastupdated > #lastread. However it doesn't always pick up all of the actual matches. For example, the story "Falling with Folded Wings" on RoyalRoad shows a #lastupdated date of "18 Aug 2022" and a #lastread date of "17 Aug 2022" but was not included in the search results. It only happens when those two dates are one day apart and even then only rarely. I don't think this can be a problem with my column definitions, but I don't have a clue what's going on. Both columns are of type Date with matching formats.

Oh, I should also mention that "Lookup/Search Name [2]" simply checks that "#lastread > 0" so it only shows stories I've started reading. I also have a Final Filter to make sure that a Yes/No flag column is set to TRUE. Those are the only things I've set within MCS. MCS normally works on the stories that it occasionally misses so I don't think the problem is other MCS settings either.

- Andrew
applegaa is offline   Reply With Quote