I am running a query on contentversion to fetch files related to opportunity from Salesforce. However the content version records returned from the query does not tell me what opportunity id is that related to. I know that ContentDocumentLink has a column called LinkedEntityId which would be opportunity id in my case.
Is there a way I can create a formula field on Contentversion object and lookup the LinkedEntityId from the contentDocumentLink? or Is there any other way to achieve this usecase?