You need to sign in to do that
Don't have an account?
Anupama@28
Soql on IdeaComment without filter by Id
Hi,
I am trying to execute the following soql queris using bulk API / workbench / Developer console, but I am not able to retrieve the result without filter on Ids.
SELECT Id FROM IdeaComment;
How do I get the result of soql queries without filter on Id.
I am trying to execute the following soql queris using bulk API / workbench / Developer console, but I am not able to retrieve the result without filter on Ids.
SELECT Id FROM IdeaComment;
How do I get the result of soql queries without filter on Id.
Here is what happend when i fired your requested Query in workbench.Please look at it.
MALFORMED_QUERY: Implementation restriction. When querying the Idea Comment object, you must filter using
the following syntax: CommunityId = [single ID], Id = [single ID], IdeaId = [single ID], Id IN [list of IDs], or IdeaId
IN [list of IDs].
As the query itself gives explaination,but here i explain for you.There are restriction applied on IdeaComment object as you can imagine there can be comments in 1000's which will hit governor limits until and unless they are specific in terms of community for which they are(Developer /Success Community)
So,Syntax for this has to be in the form mentioned by error given in bold.
If this fulfills your query mark it as best asnwer.
Regards
Nitesh
We get same issue with many such objects like IdeaComment, Vote , Knowledge Articles etc..
Is there any way to differentiate such objects from other objects?
Also . While processing objects like Task priority, casestatus etc. we are getting the error as “Entity 'Casestatus' is not supported by the Bulk API”. What could be the reason for this. Where as I am able extract the data using workbench / developer console.
Thanks.
May be you are hitting Bulk api limits somewhere.