You need to sign in to do that
Don't have an account?

Entity 'ContentDocumentLink' is not supported for semi join inner selects
Hi,
I'm attempting to create a SOQL query (to merge data via Conga). Specificically, I would like to retrieve records from the object "ContentVersions" as they relate to Files (ContentDocument) attached to a custom object called (Transmittal). I am retireving them from Transmittal. I have written the following:
My query returns the following error, "Entity 'ContentDocumentLink' is not supported for semi join inner selects".
The sturcture, as I understand it is:
Transmittal
ContentDocumentLink (creates a m to m relationship between the Linked Entity (here Transmittal) and ContentDocument.
ContentDocument
Content Versions
I have reviewed the Content Object schema.
Is the query incorrect, or is it not supported? If not what is a work-around? (Sorry I'm an amateur).
Thank for your help.
I'm attempting to create a SOQL query (to merge data via Conga). Specificically, I would like to retrieve records from the object "ContentVersions" as they relate to Files (ContentDocument) attached to a custom object called (Transmittal). I am retireving them from Transmittal. I have written the following:
SELECT v.Title, v.FileType
FROM ContentVersion v
WHERE ContentDocumentId in
(Select j.ContentDocumentId From ContentDocumentLink j
Where j.LinkedEntityId = '{pv0}')
FROM ContentVersion v
WHERE ContentDocumentId in
(Select j.ContentDocumentId From ContentDocumentLink j
Where j.LinkedEntityId = '{pv0}')
My query returns the following error, "Entity 'ContentDocumentLink' is not supported for semi join inner selects".
The sturcture, as I understand it is:
Transmittal
ContentDocumentLink (creates a m to m relationship between the Linked Entity (here Transmittal) and ContentDocument.
ContentDocument
Content Versions
I have reviewed the Content Object schema.
Is the query incorrect, or is it not supported? If not what is a work-around? (Sorry I'm an amateur).
Thank for your help.
not supported

Did you ever get an answer? I have exactly the same problem :(