Hi !
First of all thank you so much for Forena Reports. Its a great module.

Today I saw screencasts of FR on youtube. I noticed that in order to create a report , we first need to write sql queries using some other software. It can be really awesome if these queries can be written in drupal itself through UI. There can be a form like this:

Select [text input box]
Group by [text input box]
etc.

Is it possible?

Thanks again!

Comments

metzlerd’s picture

metzlerd commented

I have thought of writing a query builder for this module, it is certainly possible, but it will likely be a separate module due to the security implications of arbitrary SQL being run against the db. In the meantime consider using a tool like phpmyadmin. If you are using a hosting provider with cpanel, you can also use the file editor on CPANEL to save the queries directly to your site.

Thanks for the feedback.

nikkubhai’s picture

nikkubhai commented

Oh Yes.I did not realize the security concerns. Yes, I will use phpymyadmin. Thanks for your reply. :)

metzlerd’s picture

metzlerd commented
Version: 7.x-2.x-dev » 7.x-3.x-dev
Assigned: Unassigned » metzlerd
Status: Active » Fixed

This was build in 7.x-3.x as the forena_query module. It supports saving of qureies into the database.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.