TDV Adapter for Sage Intacct

Build 22.0.8462

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>
  

String cmd = "GETDELETED FROM Customer WHERE WhenModified >='2013-01-01' AND WhenModified <='2013-02-01'";
PreparedStatement pstmt = connection.prepareStatement(cmd);
ResultSet rs = pstmt.getResultSet();
while(rs.next()){	
  System.out.println(rs.getString("Id"));
}
connection.close();

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462