Winter'18 - Parent Relationship query on DuplicateRecordSet fails
Last updated 2018-02-10 ·Reference W-4300707 ·Reported By 2 users
SOQL on DuplicateRecordSet like :
"Select DuplicateRule.MasterLabel from DuplicateRecordSet"
Get this error:
Select DuplicateRule.MasterLabel from DuplicateRecordSet
ERROR at Row:1:Column:8
No such column 'MasterLabel' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
Except for DuplicateRule.id, DuplicateRule.Name and DuplicateRule.IsActive, SOQL parent relationship query fails for all other fields for DuplicateRecordSet.
Run the above query in Workbench/Developer Console
Use the following query instead :
"select sobjectType, masterlabel, developername, isactive, language from DuplicateRule where id in (select DuplicateRuleId from DuplicateRecordSet)"
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.