[SalesForce] Knowledge – How to filter SOSL results by a SOQL and save on API calls

My organization frequently does work with SalesForce knowledge. And the recommended way to search Knowledge is either by the exact type of the article that you created in your instance or by the KnowledgeArticleVersion table, which contains the title and the published channels (internal/public/customer portal/app portal). The inherent problem with this is that you inevitably want to search the type of the article with SOSL, but you then need the channels as well – which can only be found in KnowledgeArticleVersion.

The only solution I can find to this is to:

SOSL search on all types (one call, multiple objects merged)
SOQL query on all articles from the category you did on KnowledgeArticleVersion (filter for internal only = true)
Use some basic set merging on the two results and filter the ones that don't have the appropriate channel out.

Ideally, I'd like to be able to run one query on my specific type and intersect it with another table – effectively SOSL search fed to a SOQL filter. Is there a way to do this?

Best Answer

Yes, there is a way to do that:

FIND 'test' RETURNING KnowledgeArticleVersion(Id, Title, Summary WHERE PublishStatus='online' AND Language= 'your language')

You can add a condition on channel and data cateogry inside as it's done with Publish Status.

Related Solutions

[SalesForce] Search all articles and receive body in single SOSL

Are you looking for a particular keyword in your custom field ? In that case if you search for a keyword (e.g. : 'test') you could use something like :

FIND {test} RETURNING
    Article_Type1__kav(Id WHERE PublishStatus='Online' AND Language='en_US'),
    Article_Type2__kav(Id WHERE PublishStatus='Online' AND Language='en_US')

This search would include your custom fields as well.

[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()); 
}

Related Topic