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?
CreatedDate and IsDeleted columns not accessible in Contact table
-
- Posts: 4
- Joined: Thu 07 Jun 2012 15:48
Re: CreatedDate and IsDeleted columns not accessible in Contact table
Please add the "System Objects=true;" entry to your connection string and call connection.Cache.RefreshMetadata().
-
- Posts: 4
- Joined: Thu 07 Jun 2012 15:48
Re: CreatedDate and IsDeleted columns not accessible in Contact table
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.
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
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
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
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 .
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 .