Raw SQL Query
Categories
Component ID
2346457
Component name
Raw SQL Query
Component type
module
Maintenance status
Development status
Component security advisory coverage
covered
Downloads
1906
Component created
Component changed
Component body
Version 7.x-1.x
It builds "tables" (mysql views using "CREATE VIEW" statement) based on raw sql queries.
I would say it is like a lightweight version of a materialized views approach.
It uses Ctools to manage data storage and PHPExcel to export data into a Excel file :)
After installation, go to admin/config/development/raw_sql_query
Do not forget clean cache after you store a query.
Version 7.x-2.x
It builds "tables" using "CREATE TABLE" statements. The approach is different from previous one to avoid permission issues related to usage of MYSQL VIEWS.
Sponsored by Drinux.