How do you select only the references without an attachment?

mtauton · Post by **mtauton** » Tue Oct 10, 2006 4:55 pm

I would like to select all the references without attachments and check for the pdf's online for downloading.

Also is there a way to determine how many of your references have an attached pdf?

Post by **Jon** » Tue Oct 10, 2006 10:03 pm

This is from the User Guide:

Show all references with or without attachments

In the List View, you can do an SQL Search or make a smart SQL/REGEX group that shows all references that do or do not have attachments. The syntax is:

Show references with attachments:

varCharField REGEX '[a-z]'

Show references without attachments:

NOT varCharField REGEX '[a-z]'

To find a specific attachment, this search will work:

Locate('my attachment name', varCharField) > 0

rmelamed · Post by **rmelamed** » Sat Oct 14, 2006 10:44 am

How do you undo the SQL query that selects files with or without attachments sothat you get all files?
Thanks, bob

Post by **Jon** » Sat Oct 14, 2006 11:43 am

Sorry, I don't understand. What exactly do you want the query to return?

Jon
Sonny Software

rmelamed · Post by **rmelamed** » Sat Oct 14, 2006 11:58 am

Once again pardon my ignorance. I forgot to select "all" in the list view.