[SalesForce] Failed: InvalidBatch : Failed to process query: FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query

I am getting below error on running bulk query.Is there any way i can get result in bulk query.

Failed: InvalidBatch : Failed to process query:
FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in
Bulk Query

I have used below bulk query in workbench.

SELECT Product__c,product__r.description FROM Sales_Quota__c

Best Answer

I think your best bet is just to define a field on the Sales_Quota__c Object called Product_Description__c, which would be a formula equal to product__r.description. Then use this in your query.

SELECT Product__c,Product_Description__c FROM Sales_Quota__c

Related Solutions

[SalesForce] SOQL query to load all documents in a content library

It seems SOQL queries with relationships are not supported in Bulk API.

There is an idea posted here

[SalesForce] Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

Inline lists can only bind to Id, not any other field. What you need is a subquery:

SELECT Account__c,Number__c,LEGACY_CUST_NUM__c 
FROM SYSTEMS__c where Account__c IN
(Select  AccountId from AccountShare 
where ( UserOrGroupId IN : map_group OR  UserOrGroupId =:userId )
AND RowCause IN ('Territory', 'TerritoryManual', 'TerritoryRule'))

If the sub-query is too complex, it may not let you, in which case you'll have to iterate through the list of shares you queried, and build the list manually.

Best Answer

Related Solutions

[SalesForce] SOQL query to load all documents in a content library

[SalesForce] Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

Related Topic