Page 1 of 1
CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Thu 07 Jun 2012 16:01
by arkajzerek
Hi,
For some reason columns IsDeleted and CreatedDate in Contact table cannot be accesses using your product, however they exists when investigating table structure using different products.
How can I access data in them?
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Mon 11 Jun 2012 10:52
by Shalex
Please add the "System Objects=true;" entry to your connection string and call connection.Cache.RefreshMetadata().
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Tue 31 Jul 2012 07:35
by arkajzerek
Further to the post above (thanks for the hint!) - how can I query deleted rows?
See my simple query:
select * from contact where isdeleted = true
Technically it works however no results are returned. The sandbox Recycle bin shows a deleted contact.
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Thu 02 Aug 2012 14:38
by Shalex
When retrieving data, we use Salesforce Web Service API's query call which does not return records from Recycle bin. We will investigate the possibility to query Recycle bin as well.
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Wed 08 Aug 2012 09:35
by Shalex
The SalesforceCommand.QueryAll property for retrieving deleted records as well is implemented (by default, false). We will post here when the corresponding build of dotConnect for Salesforce is available for download.
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Posted: Fri 10 Aug 2012 10:16
by Shalex
New build of dotConnect for Salesforce 1.2.171 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/salesf ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to
http://forums.devart.com/viewtopic.php?f=38&t=24675 .