Skip to main content
John Morgenthaler a posé une question dans #CRM Configuration

Is there a way to query which fields are being used by DLRS? In the below example I would expect if I query Name = 'xyz' I would get some results but my query brings back nulls and NA for every field except Name. I manually checked one DLRS and I except something other than null or NA. Any ideas? 

 

SELECT

    Name,

    dlrs__AggregateResultField__c,  

    dlrs__ChildObject__c,   

    dlrs__FieldToAggregate__c,

    dlrs__ParentObject__c,

    dlrs__RelationshipCriteria__c,

    dlrs__RelationshipCriteriaFields__c,

    dlrs__RelationshipField__c

    FROM 

    dlrs__LookupRollupSummary__c

    WHERE Name = 'xyz'

1 réponse
  1. 24 mars 2023, 01:44

    Hello @John Morgenthaler,

     

    This just worked for me in an org where I have DLRS installed. There is no Name field, but MasterLabel is basically the Name field so you could filter on Master Label or just leave it wide open if you want all your DLRS records.

     

    SELECT Id, MasterLabel, dlrs__AggregateResultField__c, dlrs__ChildObject__c,

    dlrs__FieldToAggregate__c, dlrs__ParentObject__c, dlrs__RelationshipCriteria__c,

    dlrs__RelationshipCriteriaFields__c, dlrs__RelationshipField__c

    FROM dlrs__LookupRollupSummary2__mdt

    WHERE MasterLabel = 'xyz'

0/9000