[DaltonST]

@Vortex:

As the ToolTips for the Special Queries Tab say, that type of query will compare every single Series in that lilbrary with every single Title in that library. You will get the results of all books with any Series in that library in its title.

By "big libraries", I can imagine that if you have a 100,000 book library and are running Calibre on a pc without a SSD, but instead are using a typical hard-drive, it will take a couple of hours.

It does not "hang", but rather is doing the search that you asked for. 100,000 titles each compared to 100,000 series equals 10,000,000,000 comparisons. That takes some time, even on an SSD. As the saying goes, be careful what you ask for; you may get it.

If you want every book that has its own series in its own title, then do not use Special Queries.

Use Intra-Book Queries with "title" "CONTAINS" "series". This will run very fast because you are comparing columns within the same book, not all columns of all books to all other books (as does Special Queries). The ToolTips explain that.

A Final Filter of "book: title" "is" "like" "(%)" works perfectly for me. So, use a plain (%) in the value column of Final Filters. The ToolTips for the operator dropdown explain the nuances of the LIKE operator.




DaltonST