Quote:
Originally Posted by BetterRed
Hmmm - you can't do a regular search on it either, e.g. EPUB file date before Jan 1 2020; but you can sort on it.
I'm half-inclined to regard that as a 'bug', I'll PM the Kovid and chaley and ask them to chime in.
|
It works if you set the sort/search type of the composite column to "date" in column setup. Example: #col:<=2017-08-01 finds the correct values in my test database.
Quote:
|
Meantime maybe this plugin can help ==>> Save Composite Custom Columns - it runs when the library is closed, but I'm not sure where it saves the composite (built from other columns) cells.
|
This is a bit complicated. The values are stored in the table "books_plugin_data" with the key (name) "CompositeColumnValues" and the book id (book). The column "val" contains the information for all the composite columns for the book as a json array {lookup_name:value, ...}