forcedotcom / forcedotcom/SFDX-Data-Move-Utility

[ISSUE] - Where Clause is not working when CSV as a Source.

Open
#1,212 0 comments 0 reactions 1 assignee Claimed by @hknokh View on GitHub
bug
Dominant language
TypeScript
Stars
548
Forks
93
PR merge metrics
No merged PRs in 30d

Description

**Issue title**
Where Clause is not working when CSV as a Source.
-- Add your title here --

**Issue summary**
We want records to be filter before insert the records to target we have CSV file is source , we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .

**Steps to reproduce**
we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .
-- Add steps to reproduce here --

**Expected behavior**
we have 67k records in CSV file but out of those we have to filter 10k rows on the basis of record type so 10K records need to be insert
-

**Actual behavior**
Describe what actually happened.
we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .

**Log file (required)**
Log file attached
**\_target.csv file (if relevant)**

** Json like -

{

"apiVersion": "51.0",
"bulkApiVersion": "2.0",
"bulkThreshold": 200,
"queryBulkApiThreshold": 10000,
"fileLog": true,
"promptOnMissingParentObjects": false,

"objects": [

{ "source": "csvfile",
"master": false,
"excluded": false,
"alwaysUseBulkApiToUpdateRecords": true,
"query": "SELECT legacy_Id__c, BillingCountry, BillingCountryCode, CreatedDate, CurrencyIsoCode, IsActive, IsDeleted, IsPersonAccount, IsPriorityRecord, LastModifiedDate, LastReferencedDate, LastViewedDate, Name, RecordTypeId, ShippingCountry, ShippingCountryCode, SystemModstamp FROM Account_Source_1 WHERE RecordTypeId = '123' AND ParentId = null",
"operation": "Upsert",
"externalId": "legacy_Id__c",
"useFieldMapping": true,
"useValuesMapping": true,
"targetRecordsFilter": "RecordTypeId = '123' AND NOT ParentId",
"fieldMapping": [
{
"targetObject": "Account"
}
],

"updateWithMockData": true,
"mockFields": [
{
"name": "Name",
"pattern": "company_name"
}
],

"useValuesMapping": true
}
]
}

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.