You need to sign in to do that
Don't have an account?
mmcconna
ActivityHistory SOQL relationship query help?
hi, bit of a problem with ActivityHistory
Documentation on ActivityHistory states:
Issue a SOQL relationship query with a main clause that references the object, and an inner clause that references the activity history, for example:
SELECT (SELECT ActivityDate, Description from ActivityHistory) FROM Account WHERE Id = '" + accId + "'"
When I issue this call from within my app:
SELECT (SELECT ActivityDate, Description from ActivityHistory) FROM Account WHERE Id = '00120000002dYd4'
the API returns me this error:
INVALID_TYPE: Didn't understand relationship 'ActivityHistory' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
So either the documentation or the API is wrong? Anyone know the correct way to get a list of activity history entries as part of an SOQL relationship query?
Cheers,
Moray
Documentation on ActivityHistory states:
Issue a SOQL relationship query with a main clause that references the object, and an inner clause that references the activity history, for example:
SELECT (SELECT ActivityDate, Description from ActivityHistory) FROM Account WHERE Id = '" + accId + "'"
When I issue this call from within my app:
SELECT (SELECT ActivityDate, Description from ActivityHistory) FROM Account WHERE Id = '00120000002dYd4'
the API returns me this error:
INVALID_TYPE: Didn't understand relationship 'ActivityHistory' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
So either the documentation or the API is wrong? Anyone know the correct way to get a list of activity history entries as part of an SOQL relationship query?
Cheers,
Moray
SELECT (SELECT ActivityDate, Description from ActivityHistories) FROM Account WHERE Id = '00120000002dYd4'
M.
Hi
Can you guic\de me if I want to extract the field values of Activity history in your query, how would I do it?