Quote:
Originally Posted by DirCat
After doing a little more research, I found a plugin that might help - Multi-Column Search. I'm going to play around with it for a bit and, if I can't figure it out, I'll ask in their forum. Thanks! 
|
And that's exactly what I needed to do. I had to install that plugin, install a SQLite viewer (to get the column names), and create 2 SQL statements (one to mark books that met the first conditions (series incomplete), and one to unmark books that no longer met the conditions (series completed).
Now I can add the marked column to my search to find which books need to be downloaded to my tablet.
In case you're interested, here's the first query:
And here's the second one:
(NOTE: The table custom_column_16 is my special table to say whether to ignore the series or not. If set to Yes (1), it means that the missing pieces aren't important (a substory or the like) and to ignore them in the first script. If set to No (0), once the conditions fail to match anymore, it will allow the second script to find them.)