function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Saikishore Reddy AengareddySaikishore Reddy Aengareddy 

Article Types Query not working

We are using different Article types and when creating article's our users select the visibility like internal app, portals, pkb etc... and for one of the article type users are selecting only pulic knowledge base. In this case when I query, the result set show zero records and If they select both Internal app and Public knowledge base as visibility, then the results show up... 

 

Is there a way to query all the articles only if public knowledge base is selected without selecting Internal App??? Is this an issue or are there any other reasons? 

 

Below is the query I am using... 

 

SELECT Title, Summary
FROM KnowledgeArticleVersion
WHERE PublishStatus='Online'
AND Language = 'en_US'
WITH DATA CATEGORY Cust_Prods__c BELOW All__c

Best Answer chosen by Admin (Salesforce Developers) 
Vinita_SFDCVinita_SFDC

Hello,

 

I think you can make a check on IsVisibleInPkb equals true but as per design if you are querying on Public knowledge base then you will have to check for Internal App also because for IsVisibleInPkb to be true IsVisibleInApp has to be true.

 

Refer:  http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_guidelines_knowledge.htm