Data Explorer Query by Tags?

I have to export 2 report from data explorer plugin through queries, but could not find query code for that. These are two different reports.

  1. Export Topic ID from Individual Tags.

How many topics created from wordpress tags?

Example: https://meta.discourse.org/t/managing-discourse-group-membership-with-wp-discourse-sso/74724

Report 1)
ID: 74724
Tag: groups
Tag: wordpress
Tag: subscriptions

  1. If any image upload in topic then it generate report.

Example: https://meta.discourse.org/t/customize-all-text-in-discourse/36092

Report 2)
ID: 36092
Image: image URL

https://meta.discourse.org/t/merge-users-core-feature-vs-plugin/153802
This url exclude from report because above post have no image.

if you find report requirement is confusing, Please let me know!

Can anyone help me, how to create query for above reports?

1 Like