I am attempting to export data using the FORCE:DATA:TREE:EXPORT CLI command, using a nested query like the following (for use in our Scratch-Orgs):
SELECT ...,(SELECT ... FROM My_Custom_Object__r) FROM Account WHERE ...
No matter what I try, I just keep getting errors. My question is two fold:
Can this sort of nested query even be performed across __r relationships where there is no explicit foreign key field (field that would otherwise have an '@Ref' value), using the FORCE:DATA:TREE:EXPORT CLI command?
If this is possible, how would an example of the nested query look for a __r relationship?