The help file suggests that ThumbsPlus will show the Windows folder icon ("Display folders -- Include folders in the thumbnail display. With this option checked, ThumbsPlus will also make thumbnails for folders, based on the current Windows thumbnail").
So, if you can get Win 11 to show those XP-style thumbnails, hopefully TP will adopt those too.
Prior to Win11 22H2, M$ removed folder thumbnails so TP10 only displays a plain folder thumbnail for any new or refreshed folders. Win11 22H2 restored a pitiful version of folder thumbnails so at least we get a stupid looking cropped single image thumbnail. WTF M$? Is there any way to make TP10 create folder thumbnails similar to XnViewMP? i.e. folder thumbnail with 1 to 4 image thumbnails within.
« Last post by Street Mann on 2022-10-08 11:27:11 »
Am trying to find that help file concerning how to structure my sql to searches of my annotations for a particular word. I hit the examples link in the help for the sql but it seems broken.... http://www.cerious.com/faq_sql.shtml
Many Thanks! I finally managed searching files using following syntax: ( tn.[taken_time_iso] > '2022-05-07 00:00:00') AND ( tn.[taken_time_iso] < '2022-05-08 00:00:00')
Most dates and times in the database are stored in unix format, i.e. seconds that have passed since jan 1, 1970. You can use the Udate command to convert them into the less cryptic ISO format that Windows uses. This is a sample query that queries the regular file date:
tn.file_time = ^udate(yyyy-mm-dd HH:mm:ss)
For a range of times/dates, you'd combine two expressions using the AND operator, like this:
(tn.file_time >= ^udate(2022-02-10)) AND (tn.file_time < ^udate(2022-02-11))
Hopefully these examples will also work when you use the tn.[taken_time_iso] field instead.
Let consider I see following in My Metadata pane Info > Date Taken : display 31/05/2022 13:59:50.825
How could I search all files from that same 'Date Taken' date : 31/05/2022 ?
I did try various combinaison like: tn.[taken_time_iso] like '2022:%:% %:%:%' or tn.[taken_time_iso] = '31/05/2022 13:59:50.825' in query Advanced pane but none give me results!
I did exactly what you said, but the resulting database was somehow corrupted.
I'm very sorry to hear that - and surprised! Did you see any error messages? The Compact & Repair function that ThumbsPlus uses is actually part of the Windows operating system, and one of its main purposes is to prevent corruption, not cause it. I hope you've been able to restore a backup.