Activity - resultsetProjection

Activity Type: Relational

Description

Project a column onto the output ResultSet of an sqlQueryStatement activity according to the parameter name or index. It should be noted that:

Example

<resultsetProjection name="projectValues">
<resultsetInput from="statementOutput"/>
<attributeName>email</attributeName>
<attributeValuesOutput name="projectOutput"/>
</resultsetProjection>

<resultsetProjection name="projectValues">
<resultsetInput from="statementOutput"/>
<attributeIndex>4</attributeIndex>
<attributeValuesOutput name="projectOutput"/>
</resultsetProjection>

Specification

Element resultsetProjection:

Input and Output Types

Data Resource Accessor

This activity can operate with any data resource accessor.

XML Schema

OGSA-DAI/schema/ogsadai/xsd/activities/resultset_projection.xsd

Class

uk.org.ogsadai.activity.sql.ResultsetProjectionActivity

Client Toolkit Class

uk.org.ogsadai.client.toolkit.activity.sql.ResultsetProjection