Page 1 of 1

sorting according to attachments

Posted: Mon May 12, 2008 12:51 pm
by melanogaster
is there a way to sort references according to the presence or absence of an attachment ?

Re: sorting according to attachments

Posted: Mon May 12, 2008 2:43 pm
by Jon
No, but you can search for references that do or don't have attachments, which may be enough. From p. 36 of the User Guide:

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


Jon
Sonny Software