How to get data from database?

Posted by CharlieCastle on September 30, 2012 at 12:02am

Hi,

I'm looking for some way (via a module?) to get data from the database and use it in a report of some kind.

For example, I want to generate a list of users who answered "Yes" in a particular poll.

The data is there in the database but I don't know how to access it.

I thought the Views module might be able to do it but it looks like it's not something that can be accessed by Views. Did I overlook a feature?

Any thoughts on how this might be done?

Thanks

Comments

=-=

Posted by VM on September 30, 2012 at 12:35am

views is indeed a query writer that extracts data from the database. Else a custom module with your own mysql query is the way forward.

The problem you 'may' run into with the core poll module is the way it stores data and whether or not views can access that storage as the responses to the polls may not be accessible in a way that views can deal with.

edit:
a deeper look into views and the core poll module- it seems the only data of the core poll module that is available to views is whether or not the poll is active. That said, the core poll module is rudimentary. You may need something more advanced that works with the voting api (which exposes a great deal more to views) like advanced poll.module, rate.module or other.

Haven't tried it, but could work

Posted by Ogion on September 30, 2012 at 1:13am

The Database Administration module has some promise but I haven't tried it myself:
http://drupal.org/project/dba
and it may (or may not) do everything you need.

Cheers,

=-=

Posted by VM on September 30, 2012 at 1:56am

it doesn't write queries. it aids with everything about a database but write queries.