Executing the report

  • Hello Scott and All,

    This plugin looks perfect for my needs, but I have an embarrassingly fundamental question. I’ve defined a group and a report, but I don’t see a way to run the report from the WP dashboard.

    Within Manage Reports, I can Edit, Duplicate, or Delete a report. Within Reports I can choose a report and it responds with View Report <reportname> and below that it says No items found.

    I don’t see an option to run the report. Is ‘No items found’ telling me I’ve overlooked something important? What am I missing? I’m using Version 0.8.1 on WP 5.01.

    Thanks for your guidance,

    Alan

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    The reports are just SQL SELECT queries. You select data and the report configuration helps you display that data in columns that are searchable, filterable, paginated, and exportable. What kind of query are you trying to do?

    Thread Starter [email protected]

    (@bakeralanbakernet)

    Thanks for your reply, Scott. I’m very familiar with SQL SELECTs and database stuff, which is why your plugin is so appealing to me.

    I’ve coded the SELECT into the SQL Query box in the Edit Report screen and pressed the Save Changes button, so now the report is all ready to run. But I don’t know the next step. How do I run the saved query?

    Regards,

    Alan

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    The query will run when you view the report. It shows the results from the query.

    Perhaps you can share details of your report with me to help you further? Send it to lol at scottkclark.com

    Please provide:

    • The SQL query you are using in the report
    • Screenshot of the edit report screen with your settings
    • Screenshot of the view report screen for your report
    • Add &debug=1 to your report URL and copy the query it gives you and include that

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Executing the report’ is closed to new replies.