You need to sign in to do that
Don't have an account?
dyndragon
Can't query ValidationStatus in KnowledgeArticleVersion
Hello,
I'm trying to query the Validation Status of a Knowledge Article Version, but even though it is documented here as a field, and my query seems correct, the error returning is that the ValidationStatus field does not exist in the sObject.
Query:
The documentation for the KnowledgeArticleVersion says I'm using this right, but for some reason it's not working. Any ideas? I am testing my query with Force.com explorer 0.58A.
I'm trying to query the Validation Status of a Knowledge Article Version, but even though it is documented here as a field, and my query seems correct, the error returning is that the ValidationStatus field does not exist in the sObject.
Query:
Select Id, Title, PublishStatus, OwnerId From FSBs__kav Where PublishStatus = 'Draft' AND ValidationStatus = 'WIP'Error:
INVALID_FIELD: Where PublishStatus = 'Draft' AND ValidationStatus = 'WIP' ^ ERROR at Row:1:Column:91 No such column 'ValidationStatus' on entity 'FSBs__kav'. 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.
The documentation for the KnowledgeArticleVersion says I'm using this right, but for some reason it's not working. Any ideas? I am testing my query with Force.com explorer 0.58A.
All Answers
For those who might find this later, use workbench:
https://workbench.developerforce.com/login.php