[
https://issues.apache.org/jira/browse/NIFI-13869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Witt updated NIFI-13869:
----------------------------
Fix Version/s: (was: 1.27.0)
> Enhance QuerySalesforceObject Processor to Support Querying Deleted Records
> ---------------------------------------------------------------------------
>
> Key: NIFI-13869
> URL: https://issues.apache.org/jira/browse/NIFI-13869
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Affects Versions: 1.25.0
> Reporter: Nicolae Puica
> Assignee: Nicolae Puica
> Priority: Major
>
> Currently, the {{QuerySalesforceObject}} processor in NiFi is capable of
> querying active records from Salesforce. However, it lacks the functionality
> to retrieve deleted records, which is critical for scenarios where we need to
> track changes or removals of records, especially for audit and compliance
> purposes. This improvement will add support for querying deleted records
> (soft deletes in Salesforce), leveraging the {{isDeleted}} field in
> Salesforce's SOQL queries.
> *Requirements:*
> # *New Processor Property:*
> ** Add a Boolean property: {{{}Include Deleted Records{}}}.
> ** When set to {{{}true{}}}, the processor should include records where the
> {{isDeleted}} field is {{{}true{}}}.
> # *SOQL Query Modification:*
> ** Modify the query structure to include the {{isDeleted}} field in the
> WHERE clause when querying the object. For example:
> *** {{{}SELECT Id, Name, IsDeleted FROM ContentVersion WHERE IsDeleted =
> true{}}}.
> # *Backward Compatibility:*
> ** Ensure backward compatibility by keeping the default behavior of
> excluding deleted records unless the new property is enabled.
> *Acceptance Criteria:*
> * Users should be able to enable or disable the querying of deleted records
> via a new processor property.
> * The processor should return both deleted and non-deleted records when
> appropriate.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
