Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejavascript
<ns:form xmlns:ns="http://www.frevvo.com/schemas/_5PqoILXnEeCqU4w2X0ufGw" name="FNLN2"> 

    <Info>    
         <Personal>       
            <FN>John</FN>       
             ...     
         </Personal>     
         ...   
    </Info> 
</ns:form>

 </pre>

Why  Why is this important? It's only important if you are using the form to edit existing submissions, i.e. to edit the XML documents they have generated. To do so, the form must first be initialized using the XML document. If the structure of the XML document does not match the structure of the form (or more accurately, if the XML schemas are incompatible), the initialization will fail and you cannot edit the submission using the form.

...

If you don't want to worry about making sure that form versions remain compatible, you can always use the from-schema bottom-up path to generate forms from XML schemas. In this case, changes to the form will not change the document since it must conform to the schema. The downside is that you must first define the XML schema and then use it in the form, which requires some technical knowledge of XML and XML schemas.<div style="font-weight:bold;background-color:#63ffc7">[[Image:Lightbulb.png]]

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

...

.

[[Image:Lightbulb.png]]

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.

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

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 frevvo submissions repository. In this example your frevvo 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:<pre> select

Code Block
languagejavascript
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
languagejavascript

...

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:<pre> select

Code Block
languagejavascript
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';

...

 
Note

Currently, if the user or app no longer exist (was deleted) the submissions will still be counted.