I am trying to extract data using Data Loader command line but can't get aliases to work.
The following SOQL query will work perfectly fine in the Developer console:
Select Hub_Name__r.Name hubName, Account__r.Name accName, Count(ID) FROM Survey_Results__c WHERE Survey_Date__c = THIS_MONTH Group By Hub_Name__r.Name, Account__r.Name ORDER By Hub_Name__r.Name ASC, Account__r.Name ASC
But when I try and run it via command line with data loader I get this error:
2020-03-20 17:10:46,534 ERROR [MgrDash_Surveys] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - No such field name hubname on entity BCS__c
So I try to remove the aliases to fix that issue but then I get this error:
2020-03-20 17:17:47,745 ERROR [MgrDash_Surveys] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - duplicate alias: Name
I have tried many ways to try and fix this but nothing seems to work. Is there some special way that aliases have to be identified with Data Loader in command line mode?