Data Explorer: Posts by Category (Including Subcategories)

Support
1

Hi everyone,

I was wondering if there was a query for posts by category. This information is available in the admin reports but I need to filter each category individually. I found mention of it here but can’t seem to find the Data Explorer Query. If anyone could help it would be greatly appreciated!

2

Are you still looking for help on this? If so…

  • Do you have the Data-Explorer plugin installed and enabled?
  • Can you navigate to [YourSite]/admin/plugins/explorer?

From there you can create your own data-explorer queries if there isn’t a default one that suits. :+1: Clicking on the plus sign next to the search box will bring up the ‘add query’ options.

Add Data Explorer Query
Add Data Explorer Query1080×764 65.4 KB

If you need help with the SQL query itself, could you be a little more specific in what data you’re looking to pull out? Is it a post count by category you’re looking for?

3 Likes
3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.