fluid-api/src/main/java/com/fluidbpm/program/api/util/sql/impl/SQLFormUtil.java
public List<Form> getFormTableForms(
			Long electronicFormIdParam,
			boolean includeFieldDataParam
	) {
		List<Form> returnVal = new ArrayList();

		if(electronicFormIdParam == null) {
			return returnVal;
		}

		Map<Long,String> definitionAndTitle =
				this.formDefUtil.getFormDefinitionIdAndTitle();

		PreparedStatement preparedStatement = null;
		ResultSet resultSet = null;
		try {
			ISyntax syntax = SyntaxFactory.getInstance().getSyntaxFor(
					this.getSQLTypeFromConnection(),
					ISyntax.ProcedureMapping.Form.GetFormContainersTableFieldFormContainers);

			preparedStatement = this.getConnection().prepareStatement(
					syntax.getPreparedStatement());

			preparedStatement.setLong(1, electronicFormIdParam);

			resultSet = preparedStatement.executeQuery();

			//Iterate each of the form containers...
			while (resultSet.next())
			{
				returnVal.add(this.mapFormContainerTo(
						definitionAndTitle,
						resultSet));
			}

			//When field data must also be included...
			if(includeFieldDataParam)
			{
				for(Form form : returnVal)
				{
					List<Field> formFields = this.fieldUtil.getFormFields(
									form.getId(),
									false,
							false);

					form.setFormFields(formFields);
				}
			}
		} catch (SQLException sqlError) {
			throw new FluidSQLException(sqlError);
		} finally {
			this.closeStatement(preparedStatement,resultSet);
		}

		return returnVal;
	}
public List<Form> getFormTableForms(
			Long electronicFormIdParam,
			boolean includeFieldDataParam
	) {
		List<Form> returnVal = new ArrayList();

		if(electronicFormIdParam == null) {
			return returnVal;
		}

		Map<Long,String> definitionAndTitle =
				this.formDefUtil.getFormDefinitionIdAndTitle();

		PreparedStatement preparedStatement = null;
		ResultSet resultSet = null;
		try {
			ISyntax syntax = SyntaxFactory.getInstance().getSyntaxFor(
					this.getSQLTypeFromConnection(),
					ISyntax.ProcedureMapping.Form.GetFormContainersTableFieldFormContainers);

			preparedStatement = this.getConnection().prepareStatement(
					syntax.getPreparedStatement());

			preparedStatement.setLong(1, electronicFormIdParam);

			resultSet = preparedStatement.executeQuery();

			//Iterate each of the form containers...
			while (resultSet.next())
			{
				returnVal.add(this.mapFormContainerTo(
						definitionAndTitle,
						resultSet));
			}

			//When field data must also be included...
			if(includeFieldDataParam)
			{
				for(Form form : returnVal)
				{
					List<Field> formFields = this.fieldUtil.getFormFields(
									form.getId(),
									false,
							false);

					form.setFormFields(formFields);
				}
			}
		} catch (SQLException sqlError) {
			throw new FluidSQLException(sqlError);
		} finally {
			this.closeStatement(preparedStatement,resultSet);
		}

		return returnVal;
	}
public List < Form > getFormTableForms ( Long electronicFormIdParam , boolean includeFieldDataParam ) { List < Form > returnVal = new ArrayList ( ) ; if ( electronicFormIdParam == null ) { return returnVal ; } Map < Long , String > definitionAndTitle = this . formDefUtil . getFormDefinitionIdAndTitle ( ) ; PreparedStatement preparedStatement = null ; ResultSet resultSet = null ; try { ISyntax syntax = SyntaxFactory . getInstance ( ) . getSyntaxFor ( this . getSQLTypeFromConnection ( ) , ISyntax . ProcedureMapping . Form . GetFormContainersTableFieldFormContainers ) ; preparedStatement = this . getConnection ( ) . prepareStatement ( syntax . getPreparedStatement ( ) ) ; preparedStatement . setLong ( 1 , electronicFormIdParam ) ; resultSet = preparedStatement . executeQuery ( ) ; //Iterate each of the form containers... while ( resultSet . next ( ) ) { returnVal . add ( this . mapFormContainerTo ( definitionAndTitle , resultSet ) ) ; } //When field data must also be included... if ( includeFieldDataParam ) { for ( Form form : returnVal ) { List < Field > formFields = this . fieldUtil . getFormFields ( form . getId ( ) , false , false ) ; form . setFormFields ( formFields ) ; } } } catch ( SQLException sqlError ) { throw new FluidSQLException ( sqlError ) ; } finally { this . closeStatement ( preparedStatement , resultSet ) ; } return returnVal ; }
Retrieves the Table field records as {@code List<Form>}.

@param electronicFormIdParam The Form Identifier.
@param includeFieldDataParam Whether to populate the return {@code List<Form>} fields.
@return {@code List<Form>} records.
Retrieves the Table field records as { @code List<Form > } .