Exports and Reports
[resolved] Custom Fields of Custom Post Type (2 posts)

  1. Burke Ingraffia
    Posted 3 years ago #

    Could you please provide me a query of a template to create a report of custom post types with custom fields?


  2. Scott Kingsley Clark
    Plugin Author

    Posted 2 years ago #

    Two reports ship with the plugin, one for Posts, one for Pages. Reporting custom fields in general can be difficult since there are variable amounts of custom fields and the database returns a big list of them instead of column-based like this plugin expects for it's MySQL queries.

    So you'd want to do a SELECT on your posts table, then do a JOIN for the postmeta table on the meta_key for each custom field, then alias each of those JOINed table meta_value columns in your SELECT for usage in the report.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Exports and Reports
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.