How to query in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow

IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to execute query in Siebel Workflow.

Add new Business Service step in Siebel Workflow, set its properties as below:

Business Service Name: EAI Siebel Adapter
Business Service Method: Query

Set the values of Input Arguments as below:

Input Argument: OutputIntObjectName
Type: Literal
Value: IO Name

Input Argument: SearchSpec
Type: Expression
Value: "[IC Name.Field Name] = '" + [&Process Property Name] + "'"

Set the values of Output Arguments as below:

Property Name: SiebelMsg 
Type: Output Argument
Output Argument: SiebelMessage

SiebelMsg is a process property with type hierarchical.

Below are some SearchSpec expressions:

"[IC Name.Field Name] = Today() AND [IC Name.Field Name] = '"+LookupValue("LOV_TYPE","Value")+"'"

"[Id]= '"+[&Object Id] +"'"

"[IC Field Name 1] <> 'NULL' AND [IC Field Name 2] <> 'Y'"

See Also:

How to Query Page in Integration Object IO and get desired number of records using EAI Siebel Adapter business service in Siebel Workflow

How to prepare Datamap using EAI Data Transformation Engine business service in Siebel Workflow

How to upsert data in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow