Advanced Search on Single Tag not returning all results

[kgladfelder]

Describe the bug/problem
When searching for a single tag (example: "Fantasy") using advanced search, about 2/3 of the actual books with the tag are returned.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Catagories'

2. Click on 'Advanced Search'
3. Enter same tag in the Tags selection box

4. Click on 'Search'
5. Number of books returned doesn't match counts for the Category tag.

Expected behavior
Same number of books are returned when searching from "Categories" or "Advanced Search"

Environment (please complete the following information):

• OS: Debian
• Python version: 3.10.6
• Calibre-Web version: 0.6.20 - 1451a67 - 2023-03-27T19:49:57+02:00
• Docker container: lscr.io/linuxserver/calibre-web:latest 0.6.20-ls204
• Special Hardware: n/a
• Browser: Vivaldi 5.7.2921.65 (Stable channel) (64-bit)

[OzzieIsaacs]

I guess you have applied some visibility restrictions (language, limit by tags or custom column) this could explain the advanced search result, which would mean the number of books in the categories section isn't correct

[OzzieIsaacs]

Okay I can reproduce it. It has nothing to do with my idea in the last topic

[OzzieIsaacs]

It has to do with the read status. Read books are not returned by the advanced search in this case. (My config uses a linked calibre database)

[OzzieIsaacs]

I understood it. It's exactly doing what we told it. But it's indeed somewhat unexpected. All field are "and" combined, meaning it's searching for title and author and "read status". The read status is set to empty by default, meaning it's responding with all books having the read status not set! We are missing the choice "any" for the read status.

[OzzieIsaacs]

Please update to the newest nightly commit, you should then get all results as you (and I) expect it

[kgladfelder]

Thanks for looking into it. Everything appears to be working how I'd expect it as well.