- 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