locked
CRM Query - Attachment ID RRS feed

  • Question

  • Hi everybody!
    I am trying to retrieve the attachment id related to a specific incident case (dbo.incident table). The attachment ID seems to be in the dbo.ActivityMimeAttachment table. Does anybody have an idea on how to link these two tables with an sql query?

    Thanks in advance!
    Tuesday, January 19, 2010 2:19 PM

Answers

  • It seems that you missed something. Attachments are saved on Annotation.

    So Query will be like:

    Declare @CaseId uniqueidentifier
    Set @CaseId = <identifier of case>
    
    Select AnnotationId From Annotation Where ObjectTypeCode = 112 and ObjectId = @CaseId

    Truth is opened the prepared mind

    My blog (english)
    Мой блог (русскоязычный)free countersLocations of visitors to this page
    • Marked as answer by M35 Tuesday, January 19, 2010 6:11 PM
    Tuesday, January 19, 2010 2:33 PM
    Moderator