I am having a problem with a query. I am trying to extract the name of
Assigned_To__c field (which is a look up field of
Employee Rosters object).
The query I have used for this is
SELECT id, name, Assigned_To__r.Name FROM Work_Request__c WHERE Assigned_To__r.id =: id limit 201
The query is returning the value for the
name fields correctly but for
id itself is getting returned not the
employee name. Can someone tell me what i'm doing wrong?