Does the adapter support querying Siebel with multiple values for match condition (e.g.select * from SR where status='open' or status='assigned')?How do we specify multiple values to the match condition?
Article ID: KB0085607
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Siebel | - |
| Not Applicable | - |
Description
Resolution:
The adapter does not support querying on multiple values for match condition. i.e., it is not supported to retrieve data with a match condition like status = "open" or "assigned".
As an alternative you could use either of the following
1.
Invoke adapter twice with one value at a time for match condition field and integrate the data
using an intermediate application like TIBCO IM/BW before sending the data to the external application.
2.
Invoke the adapter with match condition field having '_Eval' condition. e.g: If Name is the configured as a match field for the service, the incoming request can have a value '_Eval(Name='test' OR Name='y')' for the field. The syntax of the _Eval condition should match Siebel specifications. Refer to the Siebel book shelf for details on specifying _Eval conditions.
The adapter does not support querying on multiple values for match condition. i.e., it is not supported to retrieve data with a match condition like status = "open" or "assigned".
As an alternative you could use either of the following
1.
Invoke adapter twice with one value at a time for match condition field and integrate the data
using an intermediate application like TIBCO IM/BW before sending the data to the external application.
2.
Invoke the adapter with match condition field having '_Eval' condition. e.g: If Name is the configured as a match field for the service, the incoming request can have a value '_Eval(Name='test' OR Name='y')' for the field. The syntax of the _Eval condition should match Siebel specifications. Refer to the Siebel book shelf for details on specifying _Eval conditions.
Issue/Introduction
Does the adapter support querying Siebel with multiple values for match condition (e.g.select * from SR where status='open' or status='assigned')?How do we specify multiple values to the match condition?
Feedback
Yes
No
Powered by
