Create a custom report using different data tables

  • Resolved snapdesign

    (@snapdesign)


    1 year, 1 month ago

    Can someone provide me with the steps to create a custom report that pulls information from different columns in different data tables within my WordPress database? All I need is a simple spreadsheet layout with the information and able to download a CSV file from it. Thanks so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 1 month ago

    Hi @snapdesign,

    You can use our SQL Query Builder to execute a create view statement between tables to pull columns from them.

    See here: SQL Query Builder

    We suggest creating a view and then, and then creating a data table app of the result.

    Here’s a short demo on how to create a view and then a data table app using the view as a data source: https://share.zight.com/KouRxKQJ

    You can then export a report using the Bulk Actions button. See here: Bulk Actions | WP Data Access

    For more information about create view statements, you can refer to this guide: SQL Views

    Hope that helps! Let us know if you have other questions. 😊

    Thread Starter snapdesign

    (@snapdesign)

    1 year, 1 month ago

    Thank you Kim! Super helpful! 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Create a custom report using different data tables’ is closed to new replies.