Changes between Initial Version and Version 1 of Ticket #10286, comment 5
- Timestamp:
- Feb 26, 2012, 9:43:53 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #10286, comment 5
initial v1 1 1 The attachments themselves are not stored in the DB, but there is some metadata. 2 {{{ 2 Try 3 {{{#!sql 3 4 SELECT id, description, filename, size 4 5 FROM attachment 5 6 WHERE type=="ticket" 6 7 }}} 8 or, to get direct links to the attachments: 9 {{{#!sql 10 SELECT 11 filename AS id, 'attachment' AS _realm, 12 "ticket" AS _parent_realm, id AS _parent_id, 13 description, size 14 FROM attachment 15 WHERE type=="ticket" 16 }}}