topic Salesforce retrieve archived records in QlikView https://community.qlik.com/t5/QlikView/Salesforce-retrieve-archived-records/m-p/1302523#M405777 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Everyone using the old Salesforce connector (Salesforce DLL) will have to upgrade to QvSalesforceConnector by July 22, 2017 when they disable TLS 1.0. In the old connector, I used to be able to retrieve archived records by using SQL SELECT_ALL on the task object. Now with the new connector, I don't know how to retrieve these <SPAN style="font-size: 10pt;">archived records. Does anyone know how? </SPAN></P></BODY></HTML> Mon, 08 May 2017 13:53:18 GMT sifatnabil 2017-05-08T13:53:18Z Salesforce retrieve archived records https://community.qlik.com/t5/QlikView/Salesforce-retrieve-archived-records/m-p/1302523#M405777 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Everyone using the old Salesforce connector (Salesforce DLL) will have to upgrade to QvSalesforceConnector by July 22, 2017 when they disable TLS 1.0. In the old connector, I used to be able to retrieve archived records by using SQL SELECT_ALL on the task object. Now with the new connector, I don't know how to retrieve these <SPAN style="font-size: 10pt;">archived records. Does anyone know how? </SPAN></P></BODY></HTML> Mon, 08 May 2017 13:53:18 GMT https://community.qlik.com/t5/QlikView/Salesforce-retrieve-archived-records/m-p/1302523#M405777 sifatnabil 2017-05-08T13:53:18Z Re: Salesforce retrieve archived records https://community.qlik.com/t5/QlikView/Salesforce-retrieve-archived-records/m-p/1302524#M405778 <HTML><HEAD></HEAD><BODY><P>Hi Sifat </P><P></P><P>I have spoken to the product team at Qlik about this and can confirm that the latest version of the connector, by default, will automatically retrieve the archived and deleted records. </P><P></P><P>The SELECT_ALL keyword therefore isn't needed anymore, and is not recognised, so by simply removing this would work for you and retrieve all records. </P><P></P><P>You can use the where clause in the LOAD statement to limit the full retrieval, eg </P><P>WHERE IsDeleted = 0; would then only pull back the current records etc. </P></BODY></HTML> Thu, 18 May 2017 08:09:42 GMT https://community.qlik.com/t5/QlikView/Salesforce-retrieve-archived-records/m-p/1302524#M405778 Anonymous 2017-05-18T08:09:42Z