...

Submissions Database

Submissions can be accessed directly via database SQL queries. By default Live Forms's submissions are stored in the built-in HSQLDB. You can easily [[V4_Installation_Instructions#Changing_from_HSQLDB_to_another_database | configure Live Forms to use a different database]] such as mySql, MS SQL Server, etc.. Doing so can make direct access to the submission database simpler.

There are many possibilities when using direct SQL queries against the Live Forms submissions repository. Several examples are described below. [http://www.frevvo.com/frevvo/web/static/contactUs Contact frevvo] for further assistance.

Count

You may have a pledge or survey form and you would like to track the number of people that have submitted your form. Here is the SQL query to retrieve the count from the Live Forms submissions repository. In this example your Live Forms designer account name is 'JoeSmith', your application name is 'Economic Impact' and your pledge form is named 'pledge2009'.

To retrieve the count of ALL submission for a specific form:

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:

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:

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';