Template search: book_producer metadata

[Comfy.n]

Hi all!

I'd like to do a template search for """book_producer""" containing "^calibre" with (formats:#=1 and formats: pdf). As shown in Calibre manual, that publication metadata field is available:


This thread provides some examples (https://www.mobileread.com/forums/sh...d.php?t=347884) however i couldn't figure how to do write that query.

Screenshot below shows what I tried, but that was just guesswork:

Any help is appreciated.

[chaley]

Originally Posted by Comfy.n

Hi all!

I'd like to do a template search for """book_producer""" containing "^calibre" with (formats:#=1 and formats: pdf). As shown in Calibre manual, that publication metadata field is available:
Attachment 197191

This thread provides some examples (https://www.mobileread.com/forums/sh...d.php?t=347884) however i couldn't figure how to do write that query.

Screenshot below shows what I tried, but that was just guesswork:
Attachment 197192
Any help is appreciated.

In both my production library and test library, "book_producer" is always empty. Do you have an example where it isn't? If so, what does it contain?

[Comfy.n]

Originally Posted by chaley

In both my production library and test library, "book_producer" is always empty. Do you have an example where it isn't? If so, what does it contain?

I can retrieve its value from CLI, with ebook-meta. Most pdf files have a value set:



I have attached pics showing the values I'd like to filter, and two pdf files that contain the book-producer value.

[Comfy.n]

Originally Posted by chaley

In both my production library and test library, "book_producer" is always empty. Do you have an example where it isn't? If so, what does it contain?

Ah, I think I see. I tried creating a custom column with {book_producer}, but it seems that's not a searchable field.

Welp. I could see many uses for that search, if it were doable.. (and I was pretty sure it was)

[chaley]

Originally Posted by Comfy.n

Ah, I think I see. I tried creating a custom column with {book_producer}, but it seems that's not a searchable field.

Welp. I could see many uses for that search, if it were doable.. (and I was pretty sure it was)

I thought that might be the case. I looked through the code and found many references to the field when processing OPFs during import and conversion but I couldn't find anywhere where it was stored into calibre's database. As you say, "welp".

In the future, you can use the template dialog to do similar tests rather than create a column. This saves updating last_modified and triggering the backup.

[Comfy.n]

Originally Posted by chaley

In the future, you can use the template dialog to do similar tests rather than create a column. This saves updating last_modified and triggering the backup.

Noted! That would be another question I've been wanting to ask. been seeing more than usual updates to last_modified, and couldn't figure what was triggering those.

[kovidgoyal]

book_producer is epub specific metadata, it's not in the standard set of builtin fields calibre supports in its database. It's present in the Metadata cclass because calibre sets it in epub files in various scenarios.