Title: Using Procedures
Last modified: April 6, 2021

---

# Using Procedures

 *  Resolved [acook7720](https://wordpress.org/support/users/acook7720/)
 * (@acook7720)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/use-procedures/)
 * Is it possible to run a report from a saved Procedure? I have a few procedures
   that create temporary tables, and then run a query based on those. I would like
   to call one of these procedures to create a report. I’ve tried the following,
   which works in the database, but not with the plugin:
    CALL get_courses(); The
   field names I used match the column names of the final SELECT query in the procedure.
   If I can’t use saved Procedures, can I run something similar with multi-step 
   queries?
    -  This topic was modified 5 years, 1 month ago by [acook7720](https://wordpress.org/support/users/acook7720/).

Viewing 1 replies (of 1 total)

 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [5 years ago](https://wordpress.org/support/topic/use-procedures/#post-14336937)
 * I have not tested procedures with Exports and Reports and unfortunately have 
   a little looking it seems like there’s not a workaround for this. I do plan on
   revisiting the functionality in this plugin at a higher level to enable things
   like this, but this is my side project and I don’t have tons of time.

Viewing 1 replies (of 1 total)

The topic ‘Using Procedures’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/use-procedures/#post-14336937)
 * Status: resolved