My very first beginner question regarding Declarative Lookup Rollup Summaries (DLRS):
I would like to filter the child records based on recordtype (child is Opportunity). When I try to use the SQL:
RecordType LIKE 'Received'
I get an error:
'No such column 'RecordType' on entity 'Opportunity'
Any ideas what I'm doing wrong?
3 réponses
Yup, I think you need to use RecordTypeID and then the ID and not the Name. You can always test your queries on the developer workbench first, which I find really helpful
Also, you should know about the DLRS group here:
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009O5p