I am using the knowledge(
Knowledge__kav) object with 4-5 custom fields.
For an article having 5 version. How can i query the archived article version with the custom field using
SELECT Id, Title, Revision_Notes__c, Short_description__c
WHERE Language= 'en_US' And PublishStatus='online'
WITH DATA CATEGORY Knowledge_Base_Category__c BELOW Download__c.
In the above query
Short_description__c are the custom fields.
I needs to get those two fields value using KnowledgeArticleVersion object.
The below is the query which i was tried but getting error
Id, KnowledgeArticleId, VersionNumber, FirstPublishedDate, LastPublishedDate, ArchivedDate, KnowledgeArticleId.Revision_Notes__c, KnowledgeArticleId.Short_description__c
WHERE PublishStatus='Archived' AND IsLatestVersion=false AND KnowledgeArticleId='kA01s0000004fMaCAI'
^ ERROR at Row:1:Column:115 Didn't understand relationship 'KnowledgeArticleId' in field path. 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.
Can some one help me to know how to get the knowledge object custom fields using the