sorting according to attachments
-
melanogaster
- Posts: 3
- Joined: Sat May 10, 2008 12:42 pm
sorting according to attachments
is there a way to sort references according to the presence or absence of an attachment ?
Re: sorting according to attachments
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
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