SQL statement not working

PowerOffliner · 05-14-2022, 01:31 AM

I hope my thread is right here?

Until version 5.40 I could send a query to show me which authors do not have a comma in the string like "Ludlum, Robert" and is sorted as column author_sort shows them.

The query string used is: " not author = "," " (1)
Also " not authors = "," "
Where as " authors = "," " shows them when including a comma.

The request ends with an empty list. No error message appears.

Since version 5.41 the query doesn't work anymore.
Does anybody know, why it doesn' work?

Configuration:
Latest version of Calibre 64 with 24.000 titles on
Windows 10-Notebook Panasonic FZ-55,
64 GB RAM + 2 TB m.2.

Thank you for reading and constructive help.

DNSB · 05-14-2022, 12:05 PM

Calibre 5.42 does not use punctuation in searches by default. See Searching broken in V5.42? for some help on this and Proposed change to library search for a possible future change.

PowerOffliner · 05-15-2022, 05:16 AM

Thank you.
I will have a look soon.
And check, what's possible.

05-14-2022, 01:31 AM	#1
PowerOffliner Member Posts: 12 Karma: 10 Join Date: Nov 2016 Location: Germany Device: Kindle Voyage+Signature	SQL statement not working I hope my thread is right here? Until version 5.40 I could send a query to show me which authors do not have a comma in the string like "Ludlum, Robert" and is sorted as column author_sort shows them. The query string used is: " not author = "," " (1) Also " not authors = "," " Where as " authors = "," " shows them when including a comma. The request ends with an empty list. No error message appears. Since version 5.41 the query doesn't work anymore. Does anybody know, why it doesn' work? Configuration: Latest version of Calibre 64 with 24.000 titles on Windows 10-Notebook Panasonic FZ-55, 64 GB RAM + 2 TB m.2. Thank you for reading and constructive help. Last edited by PowerOffliner; 05-14-2022 at 01:33 AM. Reason: More information

05-14-2022, 12:05 PM	#2
DNSB Bibliophagist Posts: 19,293 Karma: 94111803 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Calibre 5.42 does not use punctuation in searches by default. See Searching broken in V5.42? for some help on this and Proposed change to library search for a possible future change. Last edited by DNSB; 05-14-2022 at 12:08 PM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre and SQL DB	testor	Library Management	4	02-20-2015 11:38 AM
SQL Queries	iain_benson	Calibre	9	06-04-2009 06:08 PM

05-15-2022, 05:16 AM	#3
PowerOffliner Member Posts: 12 Karma: 10 Join Date: Nov 2016 Location: Germany Device: Kindle Voyage+Signature	Thank you. I will have a look soon. And check, what's possible.

Advert