sqlSelectAction

OIE

• sqlSelectAction
  • Parameters
  • Example
  • Possible Errors

sqlSelectAction

Perform the specified query and select the results into the output message.

See also:
- [sqlUpdateAction]
- [sqlInsertAction]
- [sqlDeleteAction]
- [sqlExecuteAction]

Parameters

Parameter	Description
dataSource	The name of the defined OIE SQL data source.
queryText	The text of the SQL query to be executed.
limit	Default: 150. A value of -1 indicates there is no limit and the results of the query will be read until the results are exhausted.
tableName	This value will be used as the “tableName” attribute of the [StandadXML] ResultSet element.
primaryKeys	Fields listed will be marked as primary keys in the query result. Multiple fields may be specified as comma separated values.
codepage	Default: UTF-8

Example

Execute the provided SQL SELECT statement the result of which will be stored as [StandardXML] in the work-flow message "daily_info"

<action name="actionActivity" id="94153ae2"
    extensionAttributes="DailyPartsNotice/94153ae2"> 
  <input property="daily_info" formatter="StandardXML"/> 
  <attributes xmlns=""> 
    <extension name="activityName">sqlSelectAction</extension> 
    <extension name="dataSource">miecr@BARNET</extension> 
    <extension name="queryText">
SELECT 
    TRIM(branch_code) AS branch_code, 
    service_parts, 
    counter_parts, 
    counter_wip, 
    parts_wip, 
    record_id, 
    TO_CHAR(TODAY - 1 UNITS DAY, '%Y-%m-%d') AS report_date 
FROM hedera_billing 
WHERE report_date = TODAY - 1 UNITS DAY;</extension> 
    <extension name="description"/> 
  </attributes> 
</action>

Possible Errors

TBD