View Single Post
Old 03-09-2019, 11:43 AM   #6
bob.f
Connoisseur
bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!bob.f has a thesaurus and is not afraid to use it!
 
Posts: 78
Karma: 99068
Join Date: Nov 2017
Device: N/A
Quote:
Originally Posted by kovidgoyal View Post
calibredb supports the full calibre search language, what are yo utrying to achieve?
I have a script that can be used to produce a selection of ten random books by creating a search filter of the form "id:x or id:y or id:z" etc.

In order to do this the script generates a count of all my unread books then generates 10 random numbers and executes a number of queries with the LIMIT 1 clause to select a random book (excluding certain criteria such as custom columns and tags).

I am aware of the read random book feature but I wanted something a little different.
bob.f is offline   Reply With Quote