Iam trying to create a SOQL to list be below output. Iam trying to identify which custom entity has the highest count of Content basis the "Type". While this can be done using code, am tryng to achieve it with single SOQL statement but has not been able to make headway. The "LinkedEntityId" in ContentDocumentLink entity does provide the complete list but am interested in identifying only the first 3 to GROUP them
Add a comment
|