Class PersistenceTemplateDataViewDefaults.Join

java.lang.Object
com.inet.report.adhoc.server.api.dataview.PersistenceTemplateDataViewDefaults.Join
Enclosing class:
PersistenceTemplateDataViewDefaults

@JsonData public static class PersistenceTemplateDataViewDefaults.Join extends Object
Define a join
  • Constructor Details

    • Join

      public Join(String fromTableAlias, String fromColumn, String toTableAlias, String toColumn)
      Create a join definition.
      Parameters:
      fromTableAlias - The alias of the table the join starts, i.e. Customer
      fromColumn - The name of the column the join starts, i.e. City
      toTableAlias - The alias of the table the join ends, i.e. Employee_Address
      toColumn - 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. Customer
      fromColumn - The name of the column the join starts, i.e. City
      toTableAlias - The alias of the table the join ends, i.e. Employee_Address
      toColumn - The name of the column the join starts, i.e. City
      joinType - 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

      public String 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

      public String 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

      public String 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

      public String 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