Re: How to extract data from Orbeon database for reports?
Posted by bsteuhl on Jan 09, 2011; 10:04pm
URL: https://discuss.orbeon.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3206350.html
--
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
URL: https://discuss.orbeon.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3206350.html
If you are using form-runner then yes Forms are stored as single xml file in eXist XML database out of the box. You can have a different persistence layer I believe but you would have to follow the documentation for this. You would have to use xquery to get the reports you want if data is in XML format. I develop outside of form runner and you can have your data stored in SQL database with SQL processor and then build SQL reports. We still store our data in eXist as single xml file and run xquery for different reports in combination with some KPI data being stored in MySQL from within Intalio BPM.
From: VBerget <[hidden email]>
To: [hidden email]
Sent: Sun, January 9, 2011 4:31:36 PM
Subject: [ops-users] How to extract data from Orbeon database for reports?
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.
Brian Steuhl
Website: http://BTMSoftwareSolutions.com
Business Email:
[hidden email]
Cell: 908-421-0742
Home Office: 732-961-3187
Google Voice: 732-800-1286 (1BTM)
RSS Feed To My Blog:
From: VBerget <[hidden email]>
To: [hidden email]
Sent: Sun, January 9, 2011 4:31:36 PM
Subject: [ops-users] How to extract data from Orbeon database for reports?
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
| Free forum by Nabble | Edit this page |