SOQL Query – How to Select Knowledge Object

I'm trying to get all articles which are published and online.
In my user I turned on all permission set and so one to have access to Knowledge.

List<Knowledge__kav> myList= [SELECT Id, KnowledgeArticleId, PublishStatus, Language, Title, Summary, ArticleNumber, ArticleType, ArticleBody__c FROM Knowledge__kav WHERE PublishStatus='Online'];

Above is my query, but in log i got sth like this.

sObject type 'Knowledge__kav' is not supported.

Can somebody know how to get all object of this type in Apex class ?

Best Answer

Knowledge can be a bit confusing to query. I don't believe querying knowledge directly is supported. However, you can query the knowledge articles per article type. For instance, if your article type is called Offer, you can query it like:

SELECT Title
FROM Offer__kav
WHERE PublishStatus='online'

Related Solutions

[SalesForce] Highlight relevant article text display on public knowledge base

Looks like the answer is in this post. I had dismissed looking at the Dynamic SOSL hits in google. https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dynamic_sosl.htm#snippet

Use Dynamic SOSL to Return Salesforce Knowledge Article Snippets To provide users with more context for articles in search results, use the SOSL WITH SNIPPET clause. Snippets make it easier for users to identify the content that they’re looking for when the search term isn’t included in the article summary field. For information about how snippets are generated, see WITH SNIPPET in the Force.com SOQL and SOSL Reference.

To use the SOSL WITH SNIPPET clause in a dynamic SOSL query at run time, use the Search.find method.

Search.SearchResults searchResults = Search.find(SOSL_search_string);

This example exercises a simple SOSL query string that includes a WITH SNIPPET clause. The example calls System.debug() to print the returned article titles and snippets. Your code would display the titles and snippets in a Web page.

Search.SearchResults searchResults = Search.find('FIND \'test\' IN ALL FIELDS RETURNING 
KnowledgeArticleVersion(id, title WHERE PublishStatus = \'Online\' AND Language = \'en_US\') WITH SNIPPET (target_length=120)');

List<Search.SearchResult> articlelist = searchResults.get('KnowledgeArticleVersion');

for (Search.SearchResult searchResult : articleList) { 
    KnowledgeArticleVersion article = (KnowledgeArticleVersion) searchResult.getSObject(); 
    System.debug(article.Title); 
    System.debug(searchResult.getSnippet()); 
}

Best Answer

Related Solutions

[SalesForce] Highlight relevant article text display on public knowledge base

Related Topic