com.inet.report

Class FieldValueProvider

java.lang.Object

com.inet.report.SQLValueProvider

com.inet.report.FieldValueProvider

All Implemented Interfaces:

CascadingSource, DynamicValueProvider, NodeParser, java.io.Serializable

Direct Known Subclasses:

CascadingValueProvider

public class FieldValueProvider
extends SQLValueProvider
implements CascadingSource

The FieldValueProvider takes one or two DatabaseFields and at run time provides the values in the fields as default values. The first DatabaseField is used to fetch the values and the second is used to fetch the default values.

Since:

7.0

See Also:

Serialized Form

Field Summary

Fields inherited from class com.inet.report.SQLValueProvider

MAX_RECORDS

Constructor Summary

Constructors

Constructor and Description
FieldValueProvider(DatabaseField values, DatabaseField descriptions, int sortType) Creates a FieldValueProvider with the given DatabaseFields.

Method Summary

Modifier and Type	Method and Description
Datasource	getDatasource() Returns the data source the query is to be run on
DatabaseField	getDescriptions() Returns the DatabaseField responsible for fetching the descriptions from.
java.lang.String	getFieldRefName() Returns the name to be used as the SQL reference name in the WHERE part of the query used by a cascading prompt referencing this as its parent.
protected java.lang.String	getSQL(java.lang.String where, boolean join, boolean distinct) Returns the query to be used, using the given String as its WHERE condition
java.lang.String	getSQL() Returns the query which is to be used for fetching the values and optionally descriptions dynamically.
int	getSortType() Returns the SortField constant specifying how the values are to be sorted.
DatabaseField	getValues() Returns the DatabaseField responsible for fetching the values from.
void	setDatasource(Datasource datasource) Sets the datasource to run the query on.
void	setDescriptions(DatabaseField descriptions) Sets the description DatabaseField.
void	setSortType(int sortType) Sets the sort type, specifying how the values are to be sorted.
void	setValues(DatabaseField values) Sets the DatabaseField for fetching the values from.

Methods inherited from class com.inet.report.SQLValueProvider

getDefaultValues

Methods inherited from interface com.inet.report.DynamicValueProvider

getDefaultValues

Methods inherited from interface com.inet.report.parser.NodeParser

isDOMParser, parseDOM, parseElement, parseEndElement, parseText

Constructor Detail

FieldValueProvider

public FieldValueProvider(DatabaseField values,
                          DatabaseField descriptions,
                          int sortType)

Creates a FieldValueProvider with the given DatabaseFields.

Parameters:

values - DatabaseField to use to fetch the values. Must not be null.

descriptions - DatabaseField to use to fetch the descriptions. May be null. If not, it must be a String field and its Tablesource must be the same as the values' TableSource

sortType - The SortField constant to specify how the values are to be sorted.

Throws:

java.lang.IllegalArgumentException - if values is null, or the table sources of the two fields are not the same or the table source comes from an SQL query

Since:

7.0

See Also:

SortField.ASCENDING_ORDER, SortField.DESCENDING_ORDER, SortField.ORIGINAL_ORDER

Method Detail

getSQL

protected java.lang.String getSQL(java.lang.String where,
                                  boolean join,
                                  boolean distinct)
                           throws ReportException,
                                  java.sql.SQLException

Returns the query to be used, using the given String as its WHERE condition

Parameters:

where - WHERE condition to use. If no WHERE condition is to be used, use an empty string.

join - if set to true, a full join on all tables of the report will be created, otherwise only a select of the single table of this value will be created

distinct - if set to true, the query will contain the DISTINCT keyword

Returns:

Query to be used for this FieldValueProvider.

Throws:

ReportException - if the database structure does allow a single joined query

java.sql.SQLException - on SQL errors during requesting metadata

Since:

i-net Clear Reports 15.0

getSQL

public java.lang.String getSQL()
                        throws ReportException,
                               java.sql.SQLException

Returns the query which is to be used for fetching the values and optionally descriptions dynamically.

Specified by:

getSQL in class SQLValueProvider

Returns:

query to be used

Throws:

ReportException - if the database structure does allow a single joined query

java.sql.SQLException - on SQL errors during requesting metadata

getSortType

public int getSortType()

Returns the SortField constant specifying how the values are to be sorted.

Returns:

sorting type for the fields

Since:

7.0

See Also:

SortField.ASCENDING_ORDER, SortField.DESCENDING_ORDER, SortField.ORIGINAL_ORDER

setSortType

public void setSortType(int sortType)

Sets the sort type, specifying how the values are to be sorted.

Parameters:

sortType - SortField constant specifying how to sort the values.

Since:

7.0

See Also:

SortField.ASCENDING_ORDER, SortField.DESCENDING_ORDER, SortField.ORIGINAL_ORDER

getDescriptions

public DatabaseField getDescriptions()

Returns the DatabaseField responsible for fetching the descriptions from. Can be null if no descriptions are to be fetched.

Returns:

DatabaseField for the descriptions

Since:

7.0

setDescriptions

public void setDescriptions(DatabaseField descriptions)

Sets the description DatabaseField. If this is null, it means there are to be no descriptions. If not null, it must come from the same Datasource and TableSource as the values DatabaseField

Parameters:

descriptions - DatabaseField for the descriptions

Since:

7.0

getValues

public DatabaseField getValues()

Returns the DatabaseField responsible for fetching the values from. Will never be null

Returns:

DatabaseField for the values.

Since:

7.0

setValues

public void setValues(DatabaseField values)

Sets the DatabaseField for fetching the values from. May not be null, and its Datasource and TableSource must be equal to those of the descriptions' field if there is one.

Parameters:

values - DatabaseField for the values

Throws:

java.lang.IllegalArgumentException - if values is null or its table source does not match the description field's table source

Since:

7.0

getDatasource

public Datasource getDatasource()

Returns the data source the query is to be run on

Specified by:

getDatasource in class SQLValueProvider

Returns:

data source to use

setDatasource

public void setDatasource(Datasource datasource)

Sets the datasource to run the query on.

Parameters:

datasource - data source to run the query on.

Throws:

java.lang.IllegalArgumentException - if datasource is null

Since:

7.0

getFieldRefName

public java.lang.String getFieldRefName()

Returns the name to be used as the SQL reference name in the WHERE part of the query used by a cascading prompt referencing this as its parent. The WHERE part of the SQL query will resemble something like "WHERE (reference name = prompt value)".

Specified by:

getFieldRefName in interface CascadingSource

Returns:

Reference name of the parent source for a cascading prompt

See Also:

CascadingValueProvider, SQLValueProvider