Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Erick YamamotoErick Yamamoto 

How can I make the SOQL return the "response"?

I'm a newbie.
I have a custom object "transaction__c" and looking in the workbench I have many fields, but doens't show the field "response_c"
Image1
 but in the object have him
User-added image

With this I made a query:
SELECT Response__c, name FROM Transaction__c where name ='test';
I execute the query and the return is
User-added image
Thanks.
Best Answer chosen by Erick Yamamoto
Boss CoffeeBoss Coffee
Yes, if you don't have at least read level permission to the field then your workbench query will not be able to find it either.

All Answers

Boss CoffeeBoss Coffee
Do you have two different custom objects for transactions?

You mention the custom object is called "transaction__c", but in the query it's "ServiceTransaction__c".
Erick YamamotoErick Yamamoto
Sorry, I miss the change, the correct is "ServiceTransaction__c", I wrong paste.

User-added image
withou the field "response__c"
User-added image
Boss CoffeeBoss Coffee
For the User you're logged in as, do you have the proper field level security to view that field?
Erick YamamotoErick Yamamoto
No, I can't see in the screen this field, this is the problem?
User-added image
Boss CoffeeBoss Coffee
Yes, if you don't have at least read level permission to the field then your workbench query will not be able to find it either.
This was selected as the best answer
Erick YamamotoErick Yamamoto
Thank you so much, in the momment I can't configure my profile, but i'm so glad to know this "function". Have a nice day.