forcedotcom / forcedotcom/SFDX-Data-Move-Utility
[ISSUE] - Where Clause is not working when CSV as a Source.
- 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
Assessment
This issue has not been assessed yet.