3

Is there a way to search articles from multiple article types and receive back custom fields for each article type with a single SOSL? Sample knowledge bases query the KnowledgeArticleVersion table. This just gives back the ID and URL to the article. I need the article "body" which is stored in the custom field.

2 Answers 2

4

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.

0

Yes, you can select which fields to return, right after opening bracket in RETURNING.

FIND {MyProspect} RETURNING Contact(FirstName, LastName LIMIT 10), Account(Name, Industry)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .