Sort by attachments

[Deckerd]

Sorry if this is a silly question,

Is there a way to sort entries by the number of paper clips shown in, what I believe is, the "Author" field? This sort would hopefully simply separate those references with one paper clip shown versus those references with two paper clips shown.

I need to go through and delete attachments manually because my database is a mess. I have no idea how to make this more automated (I've already used the remove duplicate function. I used strict criteria first, and then moved to less and less). In any case, there are still attachments that I need to delete.

Thanks for the help,

Tim

[Jon]

You can create a smart SQL group (or just do an SQL search) for this

varCharField REGEX '[\n\r]'

That should find references with more than one attachment.

Jon
Sonny Software

[Deckerd]

Thank you! Still trying to figure out how to do SQL searches using documentation online.

[Jon]

Use the User Guide (Help menu). There's lots of info about SQL searches in the PDF that you have on the HD, with many examples.

Jon
Sonny Software