FormDataDao

• org.joget.apps.form.dao.FormDataDao
• Under wflow-core module
• Service method used to manage form data in database

 

Code Sample

import org.joget.apps.app.service.AppUtil;
import org.joget.apps.form.dao.FormDataDao;
import org.joget.apps.form.model.FormRow;
 
FormDataDao formDataDao = (FormDataDao) AppUtil.getApplicationContext().getBean("formDataDao");
  
String formId = "crm_account";
String tableName = "crm_account";
String id = "0001";
  
//Get the record
FormRow row = formDataDao.load(formId, tableName, id);

 

Methods 

clearFormCache

public void clearFormCache(org.joget.apps.form.model.Form form)

Clear cache for a form.

 

count

public java.lang.Long count(org.joget.apps.form.model.Form form, final java.lang.String condition, final java.lang.Object[] params)

Query total row count for a form.

 

count

public java.lang.Long count(java.lang.String formDefId, java.lang.String tableName, final java.lang.String condition, final java.lang.Object[] params)

Query total row count for a form.

 

delete

public void delete(org.joget.apps.form.model.Form form, java.lang.String[] primaryKeyValues)

Delete form data by primary keys.

 

delete

public void delete(java.lang.String formDefId, java.lang.String tableName, java.lang.String[] primaryKeyValues)

Delete form data by primary keys.

 

delete

public void delete(java.lang.String formDefId, java.lang.String tableName, org.joget.apps.form.model.FormRowSet rows)

Delete form data by rows.

 

find

public org.joget.apps.form.model.FormRowSet find(org.joget.apps.form.model.Form form, final java.lang.String condition, final java.lang.Object[] params, final java.lang.String sort, final java.lang.Boolean desc, final java.lang.Integer start, final java.lang.Integer rows)

Query to find a list of matching form rows.

 

find

public org.joget.apps.form.model.FormRowSet find(java.lang.String formDefId, java.lang.String tableName, final java.lang.String condition, final java.lang.Object[] params, final java.lang.String sort, final java.lang.Boolean desc, final java.lang.Integer start, final java.lang.Integer rows)

Query to find a list of matching form rows.

 

findPrimaryKey

public java.lang.String findPrimaryKey(org.joget.apps.form.model.Form form, final java.lang.String fieldName, final java.lang.String value)

Query to find find primary key based on a field name and it's value.

 

findPrimaryKey

public java.lang.String findPrimaryKey(java.lang.String formDefId, java.lang.String tableName, final java.lang.String fieldName, final java.lang.String value)

Query to find find primary key based on a field name and it's value.

 

getEntityName

public java.lang.String getEntityName(java.lang.String tableName, java.lang.String columnName)

Returns EntityName of form mapped to a table & column.

 

getFormDefinitionColumnNames

public java.util.Collection<java.lang.String> getFormDefinitionColumnNames(java.lang.String tableName)

Returns collection of all columns from forms mapped to a table.

 

getFormEntityName

public java.lang.String getFormEntityName(org.joget.apps.form.model.Form form)

Gets the generated hibernate entity name for the form.

 

getFormEntityName

public java.lang.String getFormEntityName(java.lang.String formDefId)

Gets the generated hibernate entity name for the form.

 

getFormRowColumnNames

public java.util.Collection<java.lang.String> getFormRowColumnNames(org.joget.apps.form.model.FormRowSet rowSet)

Returns collection of all column names to be saved.

 

getFormTableName

public java.lang.String getFormTableName(org.joget.apps.form.model.Form form)

Gets the defined table name for the form.

 

getFormTableName

public java.lang.String getFormTableName(java.lang.String formDefId, java.lang.String tableName)

Gets the defined table name for the form.

 

load

public org.joget.apps.form.model.FormRow load(org.joget.apps.form.model.Form form, java.lang.String primaryKey)

Loads a data row for a form based on the primary key.

 

load

public org.joget.apps.form.model.FormRow load(java.lang.String formDefId, java.lang.String tableName, java.lang.String primaryKey)

Loads a data row for a form based on the primary key.

 

loadByTableNameAndColumnName

public org.joget.apps.form.model.FormRow loadByTableNameAndColumnName(java.lang.String tableName, java.lang.String columnName, java.lang.String primaryKey)

Loads a data row for a table based on the primary key.

Paramaters:

columnName - is not used

 

loadWithoutTransaction

public org.joget.apps.form.model.FormRow loadWithoutTransaction(org.joget.apps.form.model.Form form, java.lang.String primaryKey)

Loads a data row for a form based on the primary key. 

This method is transactional (since v5), but retains the method name for backward compatibility reasons.

 

loadWithoutTransaction

public org.joget.apps.form.model.FormRow loadWithoutTransaction(java.lang.String formDefID, java.lang.String tableName, java.lang.String primaryKey)

Loads a data row for a form based on the primary key. 

This method is transactional (since v5), but retains the method name for backward compatibility reasons.

 

saveOrUpdate

public void saveOrUpdate(org.joget.apps.form.model.Form form, org.joget.apps.form.model.FormRowSet rowSet)

Saves (creates or updates) form data.

 

saveOrUpdate

public void saveOrUpdate(java.lang.String formDefId, java.lang.String tableName, org.joget.apps.form.model.FormRowSet rowSet)

Saves (creates or updates) form data.

 

updateSchema

public void updateSchema(org.joget.apps.form.model.Form form, org.joget.apps.form.model.FormRowSet rowSet)

Call Hibernate to update DB schema.

 

updateSchema

public void updateSchema(java.lang.String formDefId, java.lang.String tableName, org.joget.apps.form.model.FormRowSet rowSet)

Call Hibernate to update DB schema.