ThumbsPlus

All forums => ThumbsPlus v10 Questions => Topic started by: jaybird23238 on 2016-09-03 11:17:36

Title: Advanced tab in find
Post by: jaybird23238 on 2016-09-03 11:17:36

Can someone help me with the correct syntax for an advanced search.

I need the equivalent of "contains" that I see in other programs.

Example: tn.[name] contains 'sea'  would find "old man of the sea.avi" and 'seaman first class.jpg' as well as "sea level.mp4"

I know a little bit about SQL but I've found that not all SQL statements work in Thumbs Plus.

Title: Advanced tab in find
Post by: Daan van Rooijen on 2016-09-03 12:12:21

> Example: tn.[name] contains 'sea'  would find "old man of the sea.avi" and 'seaman first class.jpg' as well as "sea level.mp4"
 
Try:  tn.[name] like '%sea%'

Title: Advanced tab in find
Post by: jaybird23238 on 2016-09-03 13:50:50

Close.  In fact, close enough that I changed the single quote (') to a double quote (") and it's doing exactly what I want.

Thanks so much for the help.

Title: Advanced tab in find
Post by: jaybird23238 on 2016-09-03 13:55:05

Not to sound ungreatful but...

Is there any way to have that search look at folder names?

Yeah, I know, don't push my luck :)

Title: Advanced tab in find
Post by: Daan van Rooijen on 2016-09-03 14:17:22

That's weird about those double quotes.. only single quotes work on my system!

> Is there any way to have that search look at folder names?
>
> Yeah, I know, don't push my luck :)

Honestly, I have no idea and I'm not exactly an SQL guru. The Advanced search field shows most fields from the database table named 'Thumbnail', but not the idPath field which should contain the files' full path. I don't know why it has been omitted, but when I try to build a query with tn.[idPath] like '%foto%', it doesn't work (even though I have many files in folders that contain the word foto).