#3 Add AND NOT to Advanced Search

[Anonymous]

In an advanced search of the database, checking the radio button for AND NOT generates an error due to bad SQL. I don't know Python, but it surely looks to me like changing line 23 of biblio/search.py to say "AND NOT" instead of "ANDNOT" probably is all that needs to be done.

On ISFDB my username is Davecat. I hope this is the correct way to submit a bug report. Thanks.

[Bill Longley]

I believe Davecat is correct and it seems to work on my local copy now. I've checked in the fix - it doesn't show up via diff as it's purely a white-space correction.

[Ahasuerus]

I have installed the new version (1.4) of the script locally and it runs, but it takes a rather long time to find the data, about 1-2 minutes for "author = heinlein AND NOT title = Friday". This could cause significant performance problems.

[Ahasuerus]

The "AND NOT" radio button has been removed from the Advanced search screen until we figure out how to make these searches run faster.

[Ahasuerus]

Changed the resolution from "Fixed" to "Postponed".

[Ahasuerus]

Moved from Bugs to Feature Requests and reworded accordingly.

[Ahasuerus]

"is not exactly" and "does not contain" implemented in:

biblio/adv_search_results.py 1.29
biblio/search.py 1.51

Installed in r2017-090 on 2017-03-03. Keeping open pending user feedback.

[Ahasuerus]

No problems reported so far. Closing the FR.