Sonny Software

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?

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

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

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

Jon
Sonny Software

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