Page History

Description

• 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