Using Procedures

  • Resolved acook7720

    (@acook7720)


    3 years, 7 months ago

    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 3 years, 7 months ago by acook7720.
Viewing 1 replies (of 1 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    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.