CreatedDate and IsDeleted columns not accessible in Contact table

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
arkajzerek
Posts: 4
Joined: Thu 07 Jun 2012 15:48

CreatedDate and IsDeleted columns not accessible in Contact table

Post by arkajzerek » Thu 07 Jun 2012 16:01

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?

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: CreatedDate and IsDeleted columns not accessible in Contact table

Post by Shalex » Mon 11 Jun 2012 10:52

Please add the "System Objects=true;" entry to your connection string and call connection.Cache.RefreshMetadata().

arkajzerek
Posts: 4
Joined: Thu 07 Jun 2012 15:48

Re: CreatedDate and IsDeleted columns not accessible in Contact table

Post by arkajzerek » Tue 31 Jul 2012 07:35

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.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: CreatedDate and IsDeleted columns not accessible in Contact table

Post by Shalex » Thu 02 Aug 2012 14:38

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.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: CreatedDate and IsDeleted columns not accessible in Contact table

Post by Shalex » Wed 08 Aug 2012 09:35

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.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: CreatedDate and IsDeleted columns not accessible in Contact table

Post by Shalex » Fri 10 Aug 2012 10:16

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 .

Post Reply