B2C Servicepublic

Reporting and Analytics for Service

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    Pavol Procka
    How to report on Archived incidents sent with Attachments?Answered
    Topic posted October 27, 2017 by Pavol ProckaSilver Crown: 22,500+ Points, last edited October 27, 2017 
    93 Views, 4 Comments
    Title:
    How to report on Archived incidents sent with Attachments?
    Content:

    Hi everyone, wishing you a nice weekend. I have a requirement to report on all Incidents sent from OSvC with an attachment in January 2017.

    I checked and the Archived Incidents has a column called File Directory (file_dir) which is supposed to show: "The name of the directory the incident's file attachments are stored in." With this however, I still seem to be getting all incidents, not just the ones with an attachment and the directory look something like 2017/212aa/16.5.0.1.0.*** - not sure what that stands for.

    When I add a column from the File Attachments (fattach) table the Archived incidents report does not return anything at all.

     

    Any ideas?

    Many thanks

    Pavol

    Best Comment

    Sheri Hastings

    I'm not positive but I don't think archived incidents are stored with attachments.  I know they cannot be updated and are read only. And the table has no join to fattach which makes me think that attachments are not stored for archived incidents.


     

    Comment

     

    • Sheri Hastings

      I'm not positive but I don't think archived incidents are stored with attachments.  I know they cannot be updated and are read only. And the table has no join to fattach which makes me think that attachments are not stored for archived incidents.


       

    • Pavol Procka

      Thanks, Sheri.

      I thought the same, was just hoping someone with a lot of expertise can correct me :)
      I tried and when I try to add the fattach table to the archived incidents table, it will not join directly. It uses the contacts table as a join, however when I run the report like that no results are returned.

      Maybe Oracle will add this in the future...

    • Sheri Hastings

      Paval
      If you join attachments to contacts you are looking at attachments for contacts,... not for archived incidents. I researched it some more and I am pretty sure that unfortunately you cannot get the attachments for archived incidents.  You could submit an enhancement request to the idea lab for saving attachments of archived incidents.

       

       

    • Pavol Procka

      Hi Sheri,

      Thanks for the clarification and I have added it to the Idea Lab ;)

      Pavol

     

    community forum