Class PersistenceTemplateDataViewDefaults.Join
java.lang.Object
com.inet.report.adhoc.server.api.dataview.PersistenceTemplateDataViewDefaults.Join
- Enclosing class:
- PersistenceTemplateDataViewDefaults
Define a join
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionReturns the table column name on the left side of the JOINReturns the table alias on the left side of the JOINint
Returns the join type.int
Returns the link type.Returns the table column name on the right side of the JOINReturns the table alias on the right side of the JOIN
-
Constructor Details
-
Join
Create a join definition.- Parameters:
fromTableAlias
- The alias of the table the join starts, i.e. CustomerfromColumn
- The name of the column the join starts, i.e. CitytoTableAlias
- The alias of the table the join ends, i.e. Employee_AddresstoColumn
- The name of the column the join starts, i.e. City- Since:
- 25.4
-
Join
public Join(String fromTableAlias, String fromColumn, String toTableAlias, String toColumn, int joinType, int linkType) Create a join definition.- Parameters:
fromTableAlias
- The alias of the table the join starts, i.e. CustomerfromColumn
- The name of the column the join starts, i.e. CitytoTableAlias
- The alias of the table the join ends, i.e. Employee_AddresstoColumn
- The name of the column the join starts, i.e. CityjoinType
- The join type. Possible values:
DatabaseTables.JOINTYPE_FULL_OUTER
DatabaseTables.JOINTYPE_INNER
DatabaseTables.JOINTYPE_LEFT_OUTER
DatabaseTables.JOINTYPE_RIGHT_OUTER
linkType
- The link type for the column link. Possible values:
DatabaseTables.JOINLINK_EQUALS
DatabaseTables.JOINLINK_GREATER_EQUALS_THAN
DatabaseTables.JOINLINK_GREATER_THAN
DatabaseTables.JOINLINK_LESS_EQUALS_THAN
DatabaseTables.JOINLINK_LESS_THAN
DatabaseTables.JOINLINK_NOT_EQUALS
- Since:
- 25.4
-
-
Method Details
-
getFromTableAlias
Returns the table alias on the left side of the JOIN- Returns:
- the table alias on the left side of the JOIN
- Since:
- 25.4
-
getFromColumn
Returns the table column name on the left side of the JOIN- Returns:
- the table column name on the left side of the JOIN
- Since:
- 25.4
-
getToTableAlias
Returns the table alias on the right side of the JOIN- Returns:
- the table alias on the right side of the JOIN
- Since:
- 25.4
-
getToColumn
Returns the table column name on the right side of the JOIN- Returns:
- the table column name on the right side of the JOIN
- Since:
- 25.4
-
getJoinType
public int getJoinType()Returns the join type. See constructor for available values.- Returns:
- the join type
- Since:
- 25.4
-
getLinkType
public int getLinkType()Returns the link type. See constructor for available values.- Returns:
- the link type
- Since:
- 25.4
-