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