2

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
2
  • 1
    I don't think this question has anything to do with translations? Simple search to find the answer here, for example success.salesforce.com/answers?id=90630000000h8WkAAI
    – Adrian Larson
    Oct 4, 2016 at 19:43
  • @adrian-I wanted for bulk query. That foreign and parent relationship is already enabled in workbench.It is just not working with bulk query.
    – Jack vardy
    Oct 4, 2016 at 19:57

2 Answers 2

1

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
1

v39.0 API is currently supporting Relationship fields.

https://developer.salesforce.com/docs/atlas.en-us.204.0.api_asynch.meta/api_asynch/asynch_api_using_bulk_query.htm

v39.0 API - Bulk API query doesn’t support the following SOQL:

  • COUNT
  • ROLLUP
  • SUM
  • GROUP BY CUBE
  • OFFSET
  • Nested SOQL queries

For v38.0 API:- Bulk API query doesn’t support the following SOQL: COUNT

  • ROLLUP
  • SUM
  • GROUP BY CUBE
  • OFFSET
  • Nested SOQL queries
  • Relationship fields

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.