>
> 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)
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3206331.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>