Package wt.query

Provides generic support for defining SQL queries (see QuerySpec and the various things that can be appended to it) in a database inedependent manner that should be used with the PersistenceManager.

See:
Description

Interface Summary

ColumnExpression	This interface defines an arbitrary expression that can be used to specify a "column" in a SQL SELECT, ORDER BY, GROUP BY or WHERE clause.
Expression	This interface defines an expression that can be used in a SQL statement.
OrderByExpression	This interface defines an expression that can be used in a SQL ORDER BY clause.
PageableSessionQuerySpec	This interface specifies the abstractions necessary to establish a persistent paging session.
PageableTableExpression	This interface specifies methods for processing TableExpressions that are part of paging queries.
RelationalExpression	This interface defines an expression that can be used as an operand in a relational expression in a SQL WHERE clause.
SearchAttributeListDelegate	Delegate interface for search attribute lists for HTML Local Search.
SQLClause	This class represents a general SQL clause.
TableExpression	This interface defines an expression that can be used to specify a "table" in a SQL FROM clause.
WhereExpression	This interface represents an expression that can be used in a SQL WHERE clause.

Class Summary

AbstractClassTableExpression	This class represents the table associated with a target class.
AbstractSubSelectTableExpression	This abstract class implements common methods for a sub-select TableExpression.
ArrayExpression	This class represents an array of constants in a SQL IN clause.
ArrayTableExpression	This class implements a TableExpression for an array of values that can be used as a table.
AttributeRange	This class specifies start and end points of a range.
AttributeRangeSearch	Extends the basic AttributeSearch class to support handling of a start-end range of attribute values.
AttributeSearchSpecification	Specifies the basic contract for a database search against an attribute of a Windchill Persistable object.
BasicPageableQuerySpec	This class provides a standard implementation for establishing a paging session.
BooleanSearch	Search for a boolean attribute.
ClassAttribute	This class represents a class attribute which can be used in a SQL statement.
ClassTableExpression	This class represents a class specification of a table which can be used in a SQL FROM clause.
ClassViewExpression	This class represents a class specification of a table which can be used in a SQL FROM clause.
ColumnListExpression	This class implments a list of ColumnExpressions.
CompositeQuerySpec	This class is a query statement specification that consists of multiple QuerySpecs that are executed as a single queru.
CompositeWhereExpression	This class represents a number of WHERE expressions connected using a logical operator (i.e.
CompoundQuerySpec	This class provides the functionality to build a compound query statement.
ConditionsClause	This class presents the conditions which can be used in SQL statemnet such as HAVING Supported API: false Extendable: false
ConditionsClause.SearchConditionInfo
ConstantExpression	This class represents a constant in a SQL statement.
DatabaseSearch	Utility class for processing the database search part of the integrated search.
DateExpression	This class represents a date constant in a SQL statement.
DateHelper	Parses a string date into a DateHelper object which contains a date object and records the last significant digit of the date or time.
dateHelperResource	dateHelperResource message resource bundle [English/US]
dateHelperResource_en_GB	dateHelperResource message resource bundle [English/US]
dateHelperResource_en_US	dateHelperResource message resource bundle [English/US]
DoSearchProcessor	Presents the local search results in the HTML Local Search UI.
EnumeratedTypeSearch	Search for a enumerated type (valid value) value.
ExistsExpression	This class represents an EXISTS expression in a WHERE clause.
ExternalTableExpression	This class represents a table which can be used in a SQL FROM clause.
FixedLengthStringExpression	This class represents a fixed length string constant in a SQL statement.
FloatRangeSearch	Search for float value via a start-end range specification.
FloatSearch	Search for a float value.
FromClause	This class represents a FROM SQL clause.
GroupByClause	This class represents a GROUP BY SQL clause.
IntegerRangeSearch	Search for integer value via a start-end range specification.
IntegerSearch	Search for an Integer attribute.
IntegratedSearchTask	Provides a search API for the client to use to get paged, sorted, and integrated database and content searches.
JoinClause	This class represents the join condition in SQL statement Supported API: false Extendable: false
JoinIndex	Supported API: false Extendable: false
KeywordExpression	This class represents an expression that evaluates to a SQL keyword that can be used in a SQL statement.
ListClause	Supported API: false Extendable: false
LocalSearchProcessor	Presents the local search criteria in the HTML Local Search UI.
LogicalOperator	This class represents a Logical Operator.
LongRangeSearch	Search for long value via a start-end range specification.
LongSearch	Search for a long value.
NavigateSpec	This class implements a specification for a navigate query.
NegatedExpression	This class represents a negation of an expression in a WHERE clause.
NullTableExpression	This class represents a null table (i.e.
ObjectReferenceSpec	Deprecated.
ObjectSearchAttributeList	SearchAttributeList There should be no strings that need localizing in here.
ObjectSearchProcessor
OrderBy	This class represents an OrderBy clause.
OrderByClause	This class represents a ORDER BY SQL clause.
PageableQuerySpec	This abstract class provides common APIs and functionality for queries that support paging.
PagingSessionSpec	This class can be used to fetch pages from an established paging session.
PrincipalTheSavedQuery	Use the newPrincipalTheSavedQuery static factory method(s), not the PrincipalTheSavedQuery constructor, to construct instances of this class.
QueryCollationKeyFactory	A collation key factory for Identified objects.
QuerySpec	This class represents a Query in terms of Windchill objects.
RangeExpression	This class represents a range in a SQL WHERE clause.
SavedQuery	Use the newSavedQuery static factory method(s), not the SavedQuery constructor, to construct instances of this class.
SearchAttributeList	Deprecated.
SearchAttributeListFactory	Factory for getting the correct search attribute list delegate for HTML Local Search.
SearchCondition	This class represents a search condition on a query.
SearchTask	Search tasks for the client.
SetOperator	This class represents a Set Operator.
SQLFunction	This class represents a SQL function within a SQL statement.
SQLFunction.Info
SQLOperator	This class represents a SQL Operator.
StringSearch	Search for a simple string value.
SubSelectExpression	This class represents a subselect which can be used in a SQL statement.
TableColumn	This class represents a table column which can be used in a SQL statement.
TimestampRangeSearch	Search for timestamp value via a start-end range specification.
TimestampSearch	Search for timestamp value via equal, greater than, or less than specification.
WhereClause	This class represents a WHERE SQL clause.
WindchillSearchService	Search service that allows the user to pass in a string representation of the where clause to perform a query.

Exception Summary

QueryException

Exception generated when a building a query using objects in wt.query package.

Package wt.query Description

Provides generic support for defining SQL queries (see QuerySpec and the various things that can be appended to it) in a database inedependent manner that should be used with the PersistenceManager.