Activity - removeDuplicates

Activity Type: Relational

Description

This activity should usually expect stream input from an sqlBag activity. It aims at removing any possible duplicate rows from the merged results of sqlBag.

Example

<sqlBag name="sqlAnd">
 <sqlStatement value="SELECT * FROM littleblackbook WHERE id=5"/>
 <timeout>100000</timeout>
 <sqlBagOutput name="sqlOutput"/>
</sqlBag>

<removeDuplicates name="uni">
 <stringsInput from="SQLQueryANDOutput"/>
 <uniqueOutput name="uniOutput"/>
</removeDuplicates>

Specification

Element removeDuplicates:

• Attribute name - unique name for the activity within the scope of a request.
• Element stringsInput(required) - define the WebRowSet input whose possible duplicate rows will be removed.
• Attribute from (optional) - name of the output from another activity which provides the value of this parameter.
• Element uniqueOutput (required) - output stream which produces a new WebRowSet document. Any possible duplicate rows are removed.
  • Attribute name - name of this output stream.

Input and Output Types

• Input: stringsInput - java.lang.String in a WebRowSet format.
• Output: uniqueOutput - java.lang.String in a WebRowSet format.

Data Resource Accessor

This activity can operate with any data resource accessor.

XML Schema

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

Class

uk.org.ogsadai.activity.sql.RemoveDuplicatesWebRowSetActivity

Client Toolkit Class

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