I created a DLRS (Declarative Lookup Roll-up Summary) on the Opportunity that counts how many Files are related to it. However, the count gives me both the Files+Notes and I only want the File count, without Notes. Any idea how to achieve this?
Example: The count says 5+1=6. I only need the 5 files.
I check the object ContentDocumentLink and dont find a way to distinguish between Files and Notes. Any idea?
Using @David Cheng idea I tried to use as the Relationship Criteria ContentDocument.FileType = 'PDF' but it looks like you can not traverse across objects in DLRS.
The query works in Workbench but not in DLRS.
Workbench SELECT count() FROM ContentDocumentLink WHERE LinkedEntityId = '0063l00000hLMbhAAG' AND ContentDocument.FileType = 'PDF'