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.
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.
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.
AnalyticFunction	Supported API: true Extendable: false
ArrayExpression	This class represents an array of constants in a SQL IN clause.
AttributeRange	This class specifies start and end points of a range.
BasicPageableQuerySpec	This class provides a standard implementation for establishing a paging session.
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.
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.
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.
FromClause	This class represents a FROM SQL clause.
IntegratedSearchTask	Provides a search API for the client to use to get paged, sorted, and integrated database and content searches.
KeywordExpression	This class represents an expression that evaluates to a SQL keyword that can be used in a SQL statement.
LogicalOperator	This class represents a Logical Operator.
NegatedExpression	This class represents a negation of an expression in a WHERE clause.
OrderBy	This class represents an OrderBy 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.
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.
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.
SetOperator	This class represents a Set Operator.
SQLFunction	This class represents a SQL function within a SQL statement.
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.

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.

The QuerySpec supports methods for using SQL based functions (SQLFunction) and keywords (KeywordExpression). The following tables describe how Windchill supports these expressions for each supported datastore.

• Functions
• Keywords