You need to sign in to do that
Don't have an account?
gmc74
SOQL question
I am a pretty novice developer, mostly hack together code to do what I need. I am writing an asp page in c# that gathers a list of current cases and I am running into an issue.
I grab a number of case fields, including one that is a lookup to a user (called RouteTo). If I grab this field, it of course returns the user id, not the person's name. If I grab RouteTo__r.Name instead of the RouteTo__c then it will return the value but it is nested, and I am not sure how to get to that in my code.
Is there a simple way to get the query to grab the name instead of the id?
Thanks for your help
Grant
I grab a number of case fields, including one that is a lookup to a user (called RouteTo). If I grab this field, it of course returns the user id, not the person's name. If I grab RouteTo__r.Name instead of the RouteTo__c then it will return the value but it is nested, and I am not sure how to get to that in my code.
Is there a simple way to get the query to grab the name instead of the id?
Thanks for your help
Grant
Console.WriteLine("{0}", row.RouteTo__r.Name);