0 Replies Latest reply: Jun 21, 2018 5:22 AM by Michael Smith RSS

    How do I go about extracting Archived Tasks/Events from Sales Force?

    Michael Smith

      I've been led to believe by our Sales Force (SF) admin that Tasks and Events are archived in their respective tables within SF after a year.  In essence what this means is that an "IsArchived" field in each of these tables for each record is changed from "false" to "true".

       

      My issue occurs in that I want to be able to report on these archived Tasks and Events.  However, when I do a "select *" extract from SF all I get is records with the "IsArchived" field equal to "false".  Following the suggestion of our SF admin, I tried to specifically call the "IsArchived" = "true" within a where statement, but this brings back no records.


      I've seen posts on this forum that have suggested using a "Select_All" statement as opposed to the usual "Select" statement, but I get an error message when I try to use "Select_All".  Indeed, another post suggests that the "Select_All" statement is now no longer needed as the normal "select" statement should bring back all SF records regardless of whether or not they've been archived.  This however isn't the case.


      Does anyone have any suggestions as to how I can extract these archived SF records?


      I should say that I've replicated the same issue in both Qlik View and Qlik Sense.