LinkedArticle (knowledge) : query the linked articles of a case

Question

I need to query all the linked articles of a case, so I just try to use this kind of query in the query editor of the developer console :

select Id from LinkedArticle where LinkedEntityId = 'the id of my case here'

But it throws me an error saying :

select Id from LinkedArticle where LinkedEntityId = '5009E000005yCEIQA2' ^ ERROR at Row:1:Column:36 No such column 'LinkedEntityId' on entity 'LinkedArticle'. 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.

But here I can see that the field exist... But I checked the workbench and for the linkedArticle object there is no LinkedEntityId field !

So how can I specify the id of the case ? I don't want to retrieve all the linkedArtcile, just for one case at a time (I will use this query in an apex class).

(I use the api version 42.0)

Answer 1

To find the knowledge articles which are linked to a Case, you need to perform query on CaseArticle object as below

SELECT KnowledgeArticleId, ArticleLanguage, ArticleVersionNumber 
FROM CaseArticle 
WHERE CaseId= '5000v000002J6Sj'

For more information, refer CaseArticle

LinkedArticle object represents Knowledge article that is attached to a work order or work order line item.