View Single Post
Old 04-08-2020, 05:55 PM   #25
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,832
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by chaley View Post
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.
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, ...}
Hi chaley, good to know some of my telepathic messages are getting through

Because it's not showing in the Advanced Search I made an assumption…:

Click image for larger version

Name:	Annotation 2020-04-09 074222.jpg
Views:	97
Size:	51.5 KB
ID:	178184

Click image for larger version

Name:	Annotation 2020-04-09 073932.jpg
Views:	101
Size:	92.9 KB
ID:	178185

Maybe that could be fixed.

I don't use MCS, I suggest kcarscadden take up why MCS doesn't allow composite date columns with the plugin's author in the MCS thread, with a reference to this one as background.

Thanks for explain on the Save . . . columns, I think kcarscadden can forget that option.

Stay safe mate, your family too.

BR

Last edited by BetterRed; 04-08-2020 at 05:57 PM.
BetterRed is offline   Reply With Quote