You need to sign in to do that
Don't have an account?
cfaherty
Case>Solutions relationship query fail
I'm getting a nonsensical error when I try a Case>Solutions relationship query.
Here's my SOQL:
SELECT (SELECT SolutionName FROM Solutions) FROM Case WHERE Id = '50050000008oyOwAAI'
Returned error:
INVALID_FIELD: No such column 'CaseId' on entity 'Solution'. 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.
This is (apparently) a Field Level Security error. I'm at a loss as to exactly why this may be, but I think that it is related to not having access to the Case object or not being able to view solutions attached to cases; it's complaining about Solution.CaseId as being invisible, so that's why I suspect that the user can't view cases. I tested this in my dev org, and the query worked. You may need to contact support if you can't puzzle this out.