Skip to main content
Delphine LAFON (Prefikar) 님이 #Integration에 질문했습니다
Hello everyone,

I need to translate a report in Opportunity object into a SOQL language.

And I search how to say all opportunities with Partner (Partner is indicated  in related list and not really an object)

Thanks
답변 1개
  1. 2022년 4월 22일 오후 3:56
    HI Delphine,

    There is no OOTB functionality to fetch SOQL query of a report in Salesforce. There is also an idea for the same- https://ideas.salesforce.com/s/idea/a0B8W00000Gdd3dUAB/how-can-i-get-the-soql-query-of-a-report-in-salesforce

    You might want to try the approach listed in https://salesforce.stackexchange.com/questions/12300/generate-soql-from-an-existing-report

    https://salesforce.stackexchange.com/questions/16910/is-there-a-way-to-get-the-soql-behind-a-report

    If this information helps, please mark the answer as best. Thank you