Apex Code Development You need to sign in to do that
Don't have an account?
soql query won't return Product lookup from Case, no such column 'Product'
Product is a standard lookup field on the Case object yet a soql query doesn't see it. I'm an admin. I have full rights to the object & field. The field is on a page layout. Why isn't it available to query? I also noticed a describe call doesn't return the field either.
SELECT ID, Product FROM Case WHERE ID='500L000000DTFao' ^ ERROR at Row:1:Column:12 No such column 'Product' on entity 'Case'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
Appreciate the link Shweta, but it's incomplete. As you can see from the image here, it's a standard field named Product. There are other standard fields highlighted here that don't show in that article either. I read this article (https://help.salesforce.com/articleView?id=cases_fields.htm&type=5) earlier today that mentions the field is only available if entitlements are set up to include products.
Even those the case page lists the API as "Product" it's actually ProductID. Thanks!
All Answers
Please find the link which will give all the standard fields on an object and there is no product field on case. You might be checking a custom field.
https://developer.salesforce.com/docs/atlas.en-us.sfFieldRef.meta/sfFieldRef/salesforce_field_reference_Case.htm
let me know if it helps.
Appreciate the link Shweta, but it's incomplete. As you can see from the image here, it's a standard field named Product. There are other standard fields highlighted here that don't show in that article either. I read this article (https://help.salesforce.com/articleView?id=cases_fields.htm&type=5) earlier today that mentions the field is only available if entitlements are set up to include products.
Even those the case page lists the API as "Product" it's actually ProductID. Thanks!