find pdf names in BE 9.0.7

eleuteruiz · Post by **eleuteruiz** » Mon Aug 28, 2006 4:57 am

In the older versions of BE, when attached pdf names were stored in keywords field, I used to search for pdf names there.

Now they are not there any more (which is an advantage in other senses). How can I search for pdf names containing a specific string? Should I do a Spotlight search or is it still possible inside BE Find feature?

Thank you.

Post by **Jon** » Mon Aug 28, 2006 6:48 am

You can find them with an SQL search.

To find all references with at least one attachment, enter this:

varcharfield REGEX '[a-z]'

To find a specific attachment, enter it's name (or part of it's name) between the single quote marks (to make it case insensitive, precede with (?i), as in

varcharfield REGEX '(?i)fred'

An alternative that is always case-insensitive is

locate('fred', varcharfield)>0

Jon
Sonny Software

eleuteruiz · Post by **eleuteruiz** » Mon Aug 28, 2006 4:13 pm

Thank you, Jon!

I was away today, but now I have tested your SQL searches, and all of them work ok.

Perhaps it could be included in BE user guide, at least I couldn't find it there.

Post by **Jon** » Mon Aug 28, 2006 4:38 pm

I believe the REGEX example was included after the last update. If not, it certainly is in the User Guide for the next update.

Jon
Sonny Software

eleuteruiz · Post by **eleuteruiz** » Mon Aug 28, 2006 4:46 pm

What certainly is not there is the field name 'varcharfield', where we are supposed to search for pdf names.