How to Report on Salesforce Knowledge Article Data Categories Using SOQL

To retrieve Data Category information for Salesforce Knowledge Articles, run a SOQL query using the Developer Console or any supported API tool.

How to Run the Data Category Query

1. In Salesforce, go to Setup and open the Developer Console.
2. In the Developer Console, select Query Editor at the bottom of the screen.
3. Enter the following query:

Select DataCategoryGroupName, Id, ParentId from Knowledge__DataCategorySelection

1. Click Execute to run the query.
2. The results return the Data Category Group Name and the associated Article ID (ParentId).

Note: Replace "Knowledge" with your article type API name if you use a custom article type. For example, if your article type is "Solution__kav", the object name is "Solution__DataCategorySelection".