oracle.ifs.search

Class AttributeSubqueryQualification

java.lang.Object

oracle.ifs.search.SearchQualification

oracle.ifs.search.AttributeQualification

oracle.ifs.search.AttributeSubqueryQualification

All Implemented Interfaces:

Serializable, Cloneable

public class AttributeSubqueryQualification
extends AttributeQualification

An AttributeSubqueryQualification encapsulates a condition on an Attribute, using a subquery to avoid a join.

This subclass of AttributeQualification inherits most of the behavior, and overrides to produce a subquery using an exists qualification of the form: exists (select 1 from inneralias where inneralias. = . and {condition} )

Version:

1.0

See Also:

Serialized Form

(Published)

Field Summary

Fields

Modifier and Type	Field and Description
protected String	m_InnerClassJoinAttribute Represents the Name of the attribute in the inner class on which to join.
protected String	m_ParentClassAlias Represents the Name of the alias used for the parent Class.
protected String	m_ParentClassJoinColumn Represents the column name in the parent class on which to join.

Fields inherited from class oracle.ifs.search.AttributeQualification

CONTAINS_WORD, DATE_COMP_DAY, DATE_COMP_HOUR, DATE_COMP_MIN, DATE_COMP_MONTH, DATE_COMP_SEC, DATE_COMP_YEAR, DOES_NOT_CONTAIN_WORD, ENDS_WITH, EQUAL, GREATER_THAN, GREATER_THAN_EQUAL, IOC_CONTAINS_WORD, IOC_LIKE, IOC_NOT_CONTAINS_WORD, IOC_NOT_LIKE, IS_NOT_NULL, IS_NULL, LESS_THAN, LESS_THAN_EQUAL, LIKE, LIKE_WITH_ESCAPE, m_Attribute, m_AttributeDataType, m_AttributeId, m_AttributeMultiValueTableSuffix, m_AVValue, m_Class, m_CompOper, m_DateCompLevel, m_DateValue, m_EscapeClause, m_IgnoreCase, m_Opers, m_ReverseOpers, m_SQLValue, m_Value, NOT_EQUAL, NOT_LIKE, NOT_LIKE_WITH_ESCAPE, QUALIFIER_NAME, STARTS_WITH

Fields inherited from class oracle.ifs.search.SearchQualification

LATE_BIND_OPER

Constructor Summary

Constructors

Constructor and Description
AttributeSubqueryQualification() Constructs an AttributeSubqueryQualification.

Method Summary

Modifier and Type	Method and Description
protected void	accept(oracle.ifs.search.SearchQualificationVisitor v) Accepts a SearchQualificationVisitor.
String	getInnerAliasName() Gets the name used for the alias of the class used in the subquery.
String	getInnerClassJoinAttribute() Gets the Attribute used for the inner Class join.
String	getParentClassAlias() Gets the name used for the parent Class alias.
String	getParentClassJoinColumn() Gets the name used for the parent Class join column.
void	setInnerClassJoinAttribute(String joinAttrName) Sets the Attribute used for the inner Class join.
void	setParentClassAlias(String parentAlias) Sets the name used for the parent Class alias.
void	setParentClassJoinColumn(String columnName) Sets the name used for the parent Class join column.
protected String	toSQL(String innerViewName, String innerAliasName, String innerJoinColumn, String condition) Returns the SQL clause that represents the qualification.

Methods inherited from class oracle.ifs.search.AttributeQualification

getAttributeClassname, getAttributeName, getDateComparisonLevel, getEscapeClauseCharacter, getNotNullOperator, getNullOperator, getNullSearchValue, getOperatorType, getValue, isCaseIgnored, isLateBound, operatorTypeName, setAttribute, setAttribute, setCaseIgnored, setDateComparisonLevel, setEscapeClauseCharacter, setOperatorType, setOperatorType, setValue, setValue, setValue, setValueLateBound, toSQL, toSQL, validateOperator

Methods inherited from class oracle.ifs.search.SearchQualification

clone

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

m_InnerClassJoinAttribute

protected String m_InnerClassJoinAttribute

Represents the Name of the attribute in the inner class on which to join.

m_ParentClassAlias

protected String m_ParentClassAlias

Represents the Name of the alias used for the parent Class.

m_ParentClassJoinColumn

protected String m_ParentClassJoinColumn

Represents the column name in the parent class on which to join.

Constructor Detail

AttributeSubqueryQualification

public AttributeSubqueryQualification()

Constructs an AttributeSubqueryQualification.

Method Detail

setInnerClassJoinAttribute

public void setInnerClassJoinAttribute(String joinAttrName)

Sets the Attribute used for the inner Class join.

Parameters:

joinAttrName - The name of the attribute in the inner class on which to join

setParentClassAlias

public void setParentClassAlias(String parentAlias)

Sets the name used for the parent Class alias.

Parameters:

parentAlias - The name used for the parent Class alias

setParentClassJoinColumn

public void setParentClassJoinColumn(String columnName)

Sets the name used for the parent Class join column.

Parameters:

columnName - The column name in the parent class on which to join

getInnerClassJoinAttribute

public String getInnerClassJoinAttribute()

Gets the Attribute used for the inner Class join.

Returns:

The name of the attribute in the inner class on which to join

getParentClassAlias

public String getParentClassAlias()

Gets the name used for the parent Class alias.

Returns:

The name used for the parent Class alias

getParentClassJoinColumn

public String getParentClassJoinColumn()

Gets the name used for the parent Class join column.

Returns:

The name column in the parent class on which to join

getInnerAliasName

public String getInnerAliasName()

Gets the name used for the alias of the class used in the subquery.

Returns:

The name used for the inner alias

accept

protected void accept(oracle.ifs.search.SearchQualificationVisitor v)
               throws IfsException

Accepts a SearchQualificationVisitor.

Calls visitAttributeSubqueryQualifier on the visitor. The code in visitAttributeSubqueryQualifier is specific to the Visitor.

Overrides:

accept in class AttributeQualification

Parameters:

v - the SearchQualificationVisitor

Throws:

IfsException - if error occurs in the visitor

toSQL

protected String toSQL(String innerViewName,
                       String innerAliasName,
                       String innerJoinColumn,
                       String condition)
                throws IfsException

Returns the SQL clause that represents the qualification.

The SQL returned is the form: exists (select 1 from innerAliasName where innerAliasName. = . and {condition} )

Parameters:

innerViewName - the inner view name

innerAliasName - the inner alias name

innerJoinColumn - the inner join column name

condition - the attribute where clause condition

Returns:

the SQL clause

Throws:

IfsException - if the operation fails