...
| Tip |
|---|
An upcoming version of frevvo (currently estimated for late Q1 or Q2 2012) will permit versioning of forms/flows so existing submissions can be edited using older versions of the form/flow. |
Submissions Database
Submissions can be accessed directly via database SQL queries. By default frevvo's submissions are stored in the built-in HSQLDB. You can easily [[V4_Installation_Instructions#Changing_from_HSQLDB_to_another_database | configure frevvo to use a different database]] such as mySql, MS SQL Server, etc.. Doing so can make direct access to the submission database simpler.
...
To retrieve the count of ALL submission for a specific form:
| Code Block | ||
|---|---|---|
| ||
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED' and fst.applicationname='Economic Impact' and fst.name='pledge2009' |
To retrieve the count of ALL submission for forms in a specific application:
| Code Block | ||
|---|---|---|
| ||
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED' and fst.applicationname='Economic Impact'; |
To retrieve the count of ALL submission for a given form designer:
| Code Block | ||
|---|---|---|
| ||
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id
and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED'; |
...