Records are returned when I execute this
sfdx force:data:soql:query -u Dev --json --query "SELECT Id, Name, (SELECT Id, Name, AccountId FROM Contacts) FROM Account WHERE Id IN ('0010z00001T1uXSAAZ','0010z00001T1SbXAAV')"
No records are returned when I execute this
sfdx force:data:tree:export -u Dev --json --query "SELECT Id, Name, (SELECT Id, Name, AccountId FROM Contacts) FROM Account WHERE Id IN ('0010z00001T1uXSAAZ','0010z00001T1SbXAAV')" --prefix export --outputdir sfdx-out --plan
In the commands above Dev is the alias of a sandbox, not a scratch org. The result is the same whether I use 15 or 18 digit record Ids in my export: {"status":0,"result":{"records":[]}}
- Why doesn't this data:tree:export command return the same records as this data:soql:query command given that the same query is used in each against the same sandbox?
- How can I troubleshoot this issue?