Support » Plugin: EZ SQL Reports Shortcode Widget and DB Backup » Bulk report creation

  • Resolved t00kie

    (@t00kie)


    Hello guys, great plugin, thanks for that!

    I have a question related to bulk reports creation. I have hundreds of users in my database and I need to create 4 identical report for each of them. So the only difference in SQL query will be WHERE condition. Is it possible somehow to import those queries somewhere in the database? Where are those report kept?

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    Thanks @t00kie,
    The reports are stored in a serialized array in the wp_options table under the option_name ‘ELISQLREPORTS_reports_array’, so it will not be a simple matter to manually insert new reports. However, I think it is relatively simple for you to just change the WHERE conditions in each variation of your report and then update the Report Name field to save the new query under a different name.

    Let me know you have any more questions on this.

Viewing 1 replies (of 1 total)
  • The topic ‘Bulk report creation’ is closed to new replies.