I'm trying to query records with their parent record name and their related records. This is my query:
SELECT Id, Name, Record_Type_Name__c, Engagement_Model__r.Name, (SELECT Contained_Product__r.Id, Contained_Product__r.ProductCode FROM Contained_Products__r) FROM Product2 WHERE Record_Type_Name__c = 'Subscription_Package'
My problem is with the Engagement_Model__r.Name, the query does not return it at all. Instead it returns Engagement_Model__c.
Anyone knows how to solve this?