Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1978

SalesForce getDeleted function does not return deleted objects list

    XMLWordPrintable

Details

    • Hide

      Import metadata for a SalesForce model
      Set up the datasource
      Create and deploy a VDB
      INSERT into Lead (LastName, FirstName, Company) values ('Tucker', 'Lavernius', 'Blue Team')
      UPDATE Lead set Company='Red and Blue are the same' where LastName = 'Tucker'
      Change the timestamp values here to values that will capture the update in the previous step.
      EXEC sf.salesforce.getupdated('Lead',

      {ts'2009-10-28 11:42:10.5'}

      ,

      {ts'2009-10-30 11:42:10.5'}

      )
      Get the ID from the result and run this query with it:
      SELECT Name, Company from Lead where id = <id>
      should result in:
      Lavernius Tucker, Red and Blue are the same
      DELETE from Lead where LastName = 'Tucker'

      Change the timestamp values here to values that will capture the delete in the previous step.
      EXEC sf.salesforce.getDeleted('Lead',

      {ts'2009-10-28 11:42:10.5'}

      ,

      {ts'2009-10-30 11:42:10.5'}

      )
      Compare the ID with the ID returned from getUpdates; they should be the same.

      Show
      Import metadata for a SalesForce model Set up the datasource Create and deploy a VDB INSERT into Lead (LastName, FirstName, Company) values ('Tucker', 'Lavernius', 'Blue Team') UPDATE Lead set Company='Red and Blue are the same' where LastName = 'Tucker' Change the timestamp values here to values that will capture the update in the previous step. EXEC sf.salesforce.getupdated('Lead', {ts'2009-10-28 11:42:10.5'} , {ts'2009-10-30 11:42:10.5'} ) Get the ID from the result and run this query with it: SELECT Name, Company from Lead where id = <id> should result in: Lavernius Tucker, Red and Blue are the same DELETE from Lead where LastName = 'Tucker' Change the timestamp values here to values that will capture the delete in the previous step. EXEC sf.salesforce.getDeleted('Lead', {ts'2009-10-28 11:42:10.5'} , {ts'2009-10-30 11:42:10.5'} ) Compare the ID with the ID returned from getUpdates; they should be the same.

    Description

      While testing the SalesForce connector, I noticed the getDeleted function was not returning any results, when there should be.

      See Steps to Reproduce.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: