Plugboard, template, and custom composite column recipes

[thiago.eec]

Hi, @chaley.

The has_note(field_name, field_value) function can find all the books that have a note for 'field_name' which value is 'field_value'.

Would it be possible to update the function so we can find books that have notes, no matter their value? Maybe setting 'field_value' to '', '*' or something like that.

[chaley]

Originally Posted by thiago.eec

Hi, @chaley.

The has_note(field_name, field_value) function can find all the books that have a note for 'field_name' which value is 'field_value'.

Would it be possible to update the function so we can find books that have notes, no matter their value? Maybe setting 'field_value' to '', '*' or something like that.

I don't understand what you want to do. Do you want a list of book ids that have a note for any value, for example all books for which any author has a note? If so, what would you do with that list? It is certainly possible to get such a list using a Python template, but I don't see the use case.

Note that field_value is for example the tag, author, or series name, not the contents of the note attached to the field.

[thiago.eec]

Originally Posted by chaley

I don't understand what you want to do. Do you want a list of book ids that have a note for any value, for example all books for which any author has a note? If so, what would you do with that list? It is certainly possible to get such a list using a Python template, but I don't see the use case.

Note that field_value is for example the tag, author, or series name, not the contents of the note attached to the field.

I just want a way to quickly filter the book list for authors that do not have a note yet, so from time to time I can add the notes.

[dunhill]

Originally Posted by thiago.eec

I just want a way to quickly filter the book list for authors that do not have a note yet, so from time to time I can add the notes.

Check this thread to see if it helps you
https://www.mobileread.com/forums/sh...1&postcount=24

[chaley]

Originally Posted by thiago.eec

I just want a way to quickly filter the book list for authors that do not have a note yet, so from time to time I can add the notes.

Or possibly the template search in the middle of this post, "item_has_notes" under the spoiler. If you use the same stored template names as I did then you would use the search

not search:"=author has notes"

[BetterRed]

Originally Posted by thiago.eec

I just want a way to quickly filter the book list for authors that do not have a note yet, so from time to time I can add the notes.

Why not look at the Author list from time to time via Manage Categories, it'll be a lot shorter and you can sort the list on the Note column to force all the sans-Note authors to the top of the list.



I have the shortcut Ctrl+Shift+C set to Manage categories, and the 'white N in a red circle' is my <config>/resources/images/note.png image.

BR

[thiago.eec]

Originally Posted by chaley

Or possibly the template search in the middle of this post, "item_has_notes" under the spoiler. If you use the same stored template names as I did then you would use the search

not search:"=author has notes"

Thank you! The first template gives me an error, but the second works just like I wanted.

[thiago.eec]

Originally Posted by BetterRed

Why not look at the Author list from time to time via Manage Categories, it'll be a lot shorter and you can sort the list on the Note column to force all the sans-Note authors to the top of the list.

Attachment 211717

I have the shortcut Ctrl+Shift+C set to Manage categories, and the 'white N in a red circle' is my <config>/resources/images/note.png image.

BR

If I could select multiple authors, this would do. But you can select only one at a time.

Also, when I click in the Notes header, I get this error:

Spoiler:

calibre, version 7.20.100
ERRO: Exceção sem tratamento: <b>IndexError</b>:tuple index out of range

calibre 7.20.100 embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: pt_BR
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 16, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 16, 0) && ACE (1, 1, 6) && Access Aide (0, 1, 15) && Annotations (1, 17, 13) && Calibre Power Search Plugin (2, 2, 0) && Check Books (0, 2, 0) && Comments Cleaner (1, 15, 0) && Count Pages (1, 13, 6) && Diaps Editing Toolbag (0, 5, 0) && Ebook Translator (2, 3, 5) && Editor Chains (1, 1, 9) && EpubCheck (0, 2, 5) && EpubMerge (3, 2, 0) && EpubSplit (3, 9, 0) && Favourites Menu (1, 3, 1) && Find Duplicates (1, 10, 9) && GR Author Notes (1, 1, 1) && Goodreads (1, 8, 2) && Goodreads Sync (1, 16, 9) && KFX metadata reader (from KFX Input) (2, 16, 0) && From KFX (2, 16, 0) && KFX Input (2, 16, 0) && Set KFX metadata (from KFX Output) (2, 11, 0) && KFX Output (2, 11, 0) && KindleUnpack - The Plugin (0, 83, 1) && Open With (1, 8, 3) && Quality Check (1, 13, 15) && Reading Goal (1, 7, 4) && ScrambleEbook (0, 6, 0) && Skoob Books (1, 5, 6) && Skoob Sync (0, 5, 7) && Sum Column (0, 3, 1) && TextDiff (1, 2, 4) && ePub Extended Metadata {Writer} (0, 11, 4) && ePub Extended Metadata {Reader} (0, 11, 4) && ePub Extended Metadata (0, 11, 4)
Traceback (most recent call last):
File "calibre\gui2\dialogs\edit_authors_dialog.py", line 558, in do_sort
IndexError: tuple index out of range

[chaley]

Originally Posted by thiago.eec

Thank you! The first template gives me an error, but the second works just like I wanted.

Note that it won't work the way you want if a book has more than one author and only one of the authors has a note. The book won't be found by search. I'll look at changing the template.

Originally Posted by thiago.eec

Also, when I click in the Notes header, I get this error:

This is a regression introduced by adding the counts column to Manage Authors. I submitted a fix.

[thiago.eec]

Originally Posted by chaley

Note that it won't work the way you want if a book has more than one author and only one of the authors has a note. The book won't be found by search. I'll look at changing the template.

Even the second template (item_has_notes)?

Originally Posted by chaley

This is a regression introduced by adding the counts column to Manage Authors. I submitted a fix.

Thank you.

[chaley]

Originally Posted by thiago.eec

Even the second template (item_has_notes)?

Yes. That template returns True ('1') if any author for the book has a note. Using "not" with this will return True if no author has a note. I think this is the wrong answer if a book has (for example) two authors where one author has a note and the other doesn't.

[chaley]

Originally Posted by chaley

This is a regression introduced by adding the counts column to Manage Authors. I submitted a fix.

The fix is now in calibre source.

[chaley]

Originally Posted by chaley

Note that it won't work the way you want if a book has more than one author and only one of the authors has a note. The book won't be found by search. I'll look at changing the template.

Originally Posted by thiago.eec

Even the second template (item_has_notes)?

Here is a template that checks if all the items for a field have a note.

python:
def evaluate(book, context):
	field_name = context.arguments[0] if context.arguments is not None and  len(context.arguments) == 1 else None
	if field_name is None:
		raise NameError("The argument for the field name wasn't provided")

	db = context.db.new_api
	items_with_notes = context.globals.get('items_with_notes')
	if items_with_notes is None:
		items_with_notes = db.get_all_items_that_have_notes(field_name)
		context.globals['items_with_notes'] = items_with_notes
		context.globals['item_name_map'] = db.get_item_name_map(field_name)
	item_name_map = context.globals['item_name_map']

	vals = book.get(field_name)
	if vals is None:
		return ''
	if isinstance(vals, str):
		vals = tuple((vals,))
	for val in vals:
		if item_name_map.get(val) not in items_with_notes:
			return ''
	return '1'

It returns '' if any item for a field, for example any author in "authors", doesn't have a note.

I stored it with the name "all_items_have_notes".

I understand that you want to know if any author for a book doesn't have a note. In this case you would use

not template:"""program: all_items_have_notes('authors')#@#:b:yes"""

[thiago.eec]

Thank you very much!

[BetterRed]

Originally Posted by thiago.eec

If I could select multiple authors, this would do. But you can select only one at a time.

FTR only.

The only reason I can imagine one would want to select multiple authors in Manage authors would be to attach the same note (or link) to multiple authors, but a subsequent change or delete to the note (or link) in one author would not ripple through to other authors.

Originally Posted by thiago.eec

Also, when I click in the Notes header, I get this error:

Spoiler:

calibre, version 7.20.100
ERRO: Exceção sem tratamento: <b>IndexError</b>:tuple index out of range

calibre 7.20.100 embedded-python: True
Windows-10-10.0.22631-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22631')
Python 3.11.5
Windows: ('10', '10.0.22631', 'SP0', 'Multiprocessor Free')
Interface language: pt_BR
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 16, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 16, 0) && ACE (1, 1, 6) && Access Aide (0, 1, 15) && Annotations (1, 17, 13) && Calibre Power Search Plugin (2, 2, 0) && Check Books (0, 2, 0) && Comments Cleaner (1, 15, 0) && Count Pages (1, 13, 6) && Diaps Editing Toolbag (0, 5, 0) && Ebook Translator (2, 3, 5) && Editor Chains (1, 1, 9) && EpubCheck (0, 2, 5) && EpubMerge (3, 2, 0) && EpubSplit (3, 9, 0) && Favourites Menu (1, 3, 1) && Find Duplicates (1, 10, 9) && GR Author Notes (1, 1, 1) && Goodreads (1, 8, 2) && Goodreads Sync (1, 16, 9) && KFX metadata reader (from KFX Input) (2, 16, 0) && From KFX (2, 16, 0) && KFX Input (2, 16, 0) && Set KFX metadata (from KFX Output) (2, 11, 0) && KFX Output (2, 11, 0) && KindleUnpack - The Plugin (0, 83, 1) && Open With (1, 8, 3) && Quality Check (1, 13, 15) && Reading Goal (1, 7, 4) && ScrambleEbook (0, 6, 0) && Skoob Books (1, 5, 6) && Skoob Sync (0, 5, 7) && Sum Column (0, 3, 1) && TextDiff (1, 2, 4) && ePub Extended Metadata {Writer} (0, 11, 4) && ePub Extended Metadata {Reader} (0, 11, 4) && ePub Extended Metadata (0, 11, 4)
Traceback (most recent call last):
File "calibre\gui2\dialogs\edit_authors_dialog.py", line 558, in do_sort
IndexError: tuple index out of range

Works for me, viz:



BR