[#CSRVY-11] Survey plugin query results - Atlassian Developer Network JIRA

Confluence Survey Plugin

Survey plugin query results

Created: 30/Jul/08 02:22 PM Updated: 10/Sep/08 05:31 AM

Component/s:

survey-macro

Affects Version/s:

1.1.6

Fix Version/s:

1.1.6

Time Tracking:

Not Specified

Environment:

Windows 2003, Confluence 2.7.3 on Websphere 6.1

Labels:

survey plugin querying results

Description

« Hide

Hi,

We have survey plugin installed and it works fine. I wanted to know where the results are stored and is there a way we can query against the results.

Regards
Siva

All

Comments

Work Log

Change History

FishEye

Crucible

Builds

Sort Order:

[ Permlink | « Hide ]

Frank Stiller added a comment - 31/Jul/08 12:34 AM

The data ist stored as propertyentries to a page. So you can get the votes by using something like:

select * from os_propertyentry where entity_key like 'vote%'

The result will give the entity_id which is the pageid which you can grab in content, e.g.

The single voters are stored in the text_val field as a comma separated list.

Hope that helps you to get some ideas for custom sql-queries.

cheers
Frank

[ Permlink | « Hide ]

Jamie added a comment - 01/Aug/08 08:03 AM - edited

Hi Frank,

Thanks for your reply. How do you execute this sql query within survey plugin ? Or I need to install sql plugin for this. If you can give me an example of the markup it would be great.

Regards
Siva

[ Permlink | « Hide ]

Frank Stiller added a comment - 01/Aug/08 08:10 AM

Siva, you have to use either a Database-Explorer for this or the sql-plugin with a datasource for your Confluence-Database (thats not default).

You cant run this sql-query otherwise. The easiest way would be to use the database-tool, like SQL Server Management Studio (for SQL Server) e.g.. (you did not mention what database you are on).

--Frank

[ Permlink | « Hide ]

Frank Stiller added a comment - 10/Sep/08 05:29 AM

if you still need assistance, dont hesitate to add a comment or reopen the issue. Otherwise this issue is solved.