Edgewall Software

Changes between Initial Version and Version 1 of Ticket #10286, comment 5


Ignore:
Timestamp:
Feb 26, 2012, 9:43:53 AM (12 years ago)
Author:
Peter Suter

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #10286, comment 5

    initial v1  
    11The attachments themselves are not stored in the DB, but there is some metadata.
    2 {{{
     2Try
     3{{{#!sql
    34SELECT id, description, filename, size
    45FROM attachment
    56WHERE type=="ticket"
    67}}}
     8or, to get direct links to the attachments:
     9{{{#!sql
     10SELECT
     11 filename AS id, 'attachment' AS _realm,
     12 "ticket" AS _parent_realm, id AS _parent_id,
     13 description, size
     14FROM attachment
     15WHERE type=="ticket"
     16}}}