Author Topic: Advanced tab in find  (Read 3950 times)

0 Members and 1 Guest are viewing this topic.

jaybird23238

  • Full Member
  • ***
  • Posts: 29
    • View Profile
Advanced tab in find
« 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.

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 933
    • View Profile
Advanced tab in find
« Reply #1 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%'
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.

jaybird23238

  • Full Member
  • ***
  • Posts: 29
    • View Profile
Advanced tab in find
« Reply #2 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.

jaybird23238

  • Full Member
  • ***
  • Posts: 29
    • View Profile
Advanced tab in find
« Reply #3 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 :)

Daan van Rooijen

  • Administrator
  • Sr. Member
  • *****
  • Posts: 933
    • View Profile
Advanced tab in find
« Reply #4 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).
I'm volunteering as a moderator - I do not work for Cerious Software, Inc.