FireDAC Components for Zoho CRM

Build 22.0.8389

GETDELETED Statements

You can issue the GETDELETED query to retrieve all records deleted from the live data for the time range specified. This query accepts a datetime value as a filter, as shown in the following example:

GETDELETED FROM <table_name> WHERE <search_condition>

<search_condition> ::= 
  {
    <expression> { = | < | <= | > | >= } [ <expression> ] 
  } [ { AND | OR } ... ]

<expression> ::=
  | @ <parameter> 
  | ?
  | <literal>
  

The following is an example query:

GETDELETED FROM Accounts WHERE TimeModified >='2013-01-01' AND TimeModified <='2013-02-01'
Note: By putting a CACHE command in front of the query, you can update the cache to remove all values that have been deleted from the data source, as shown in the following example:
CACHE GETDELETED FROM [TableName] WHERE TimeModified >='2013-01-01' AND TimeModified <='2013-02-01'

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389