Posted by VBerget on Jan 09, 2011; 9:31pm
URL: https://discuss.orbeon.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331.html

Hi,

We are considering using Orbeon for a new project where forms filled in by users are a central part of the solution.   We have done som testing and buildt a few forms, but here is a one question that we have:

As I understand it, the results from filling out a form is stored as a single XML-entry in the database (is this correct?).  
What we need to do is generate a number of reports that summarizes data from all "instances" of a filled out form.  Example:  what percentage chose alternative 'A' in a specific form
In a pure SQL world, an example of what we need would be something like "select result_of_question_xx from forms_result where form_name = 'YYY'

I see that the SQL Processor allows SQL-queries against the database. Can this be used to query the forms results, or do we need to use another mechanism to query for data like this?
 
(The database will probably be Oracle)