Hi I am writing a SOQL query. I use Fuse IT to check my SOQL queries. So the Query is:

Select Id,Name,Material__r.APS_Account__r.FirstName, Material__r.APS_Account__r.LastName from Material_Order

In this query the Material Order has a look up to Material and the MAterial has a look up to Account. So i am trying to get FirstName and LastName of Account from Material_Order. The query works but i get the result as eg resultset for the field Material__r.APS_Account__r.FirstName = Account Dave Scott(where Dave is the Firstname and Scott is the LastName). Account keeps appending it for the result I need to know how to remove the word account from my result.

Any help would be appreciated. Thanks in Advance

  • are you sure it is not added in name . try to run this query from Developer console. – Tushar Sharma Feb 11 '16 at 16:47
  • Hi Tushaar. I ran it. here it shows the result as [object Object] for the field – Dino Feb 11 '16 at 16:53
  • try to debug the record and then Check. – Tushar Sharma Feb 11 '16 at 16:54
  • It showed up properly in the workbench. I don't know why it was showing like that in the fuse extension – Dino Feb 11 '16 at 19:15
  • 3
    @Dino then i think it is related to FuseIt and you should contact their support. – Tushar Sharma Feb 12 '16 at 2:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.