QuerySelect Properties

Description

This property returns a reference to a QueryCriteria Collection for the simple criteria of the SELECT (that is, the criteria that are used in the where clause of the select statement.)

This property is read-only.

Description

This property specifies if the Select is distinct or not.

This property takes a Boolean value: True if the query is distinct, False if the query isn't distinct.

This property is read/write.

Description

This property returns a reference to a QueryExpression Collection.

This property is read-only.

Description

This property returns a reference to a QueryCriteria collection populated with Having criteria.

This property is read-only.

Description

This property returns the select number of the parent select of the current select object. Every QuerySelect is assigned a unique number indicating its place in the hierarchy of select statements. For the Main Select, this number is zero. For unions, this number is 1 (unions aren't allowed in subqueries.)

This property is read-only.

Description

This property returns a reference to a QueryField Collection made up of QueryOutputFields.

The collection of QueryOutputFields does not necessarily include all columns returned in query resultset. This collection only includes columns that have been added to query output collection using the query classes or by an end-user designing a query.

PeopleSoft Query can also add additional columns for related language processing and also for translate labels on fields, and so you cannot use the Query Output Collections as a way to discover all of the columns that are returned in the resultset or by executing the SQL generated from a query.

This is property is read-only.

Description

This property returns a reference to a QueryRecord Collection for the query.

This is property is read-only.

Description

This property returns a reference to a QueryField Collection made up of QuerySelectedFields.

This is property is read-only.

Description

This property returns all the QuerySelect objects that are children of the current select statement as a QuerySelect collection. If the query contains unions, this property contains unions and subqueries (if any criteria contain subqueries). For all other selects, this property contains only the subqueries (because PeopleSoft Query doesn't allow unions for sub-queries).

This is property is read-only.

Description

This property returns the select number of the current select. Every QuerySelect is assigned a unique number indicating its place in the hierarchy of select statements. For the Main Select, this number would be 1.

This property is read-only.

Description

This property specifies what type of select statement. You can check for either a numeric or a constant value. The values are:

This property is read-only.