Information in this document applies to any platform.
***Checked for relevance on 15-OCT-2010***
Using the Siebel Web UI DDK when a query using NOT LIKE is executed, the following error is received
Invalid operator: (SBL-EAI-13006)
CauseThis issue has been caused by unsupported feature. EAI UI Data Adapter Business Service Methods / QueryPage Method does not support " NOT LIKE " operator.
When NOT LIKE operator is used the following error message is experienced.
Invalid operator: NOT LIKE 'TEST'(SBL-EAI-13006)
As described in Siebel Bookshelf EAI UI Data Adapter Business Service /Query Page method only supports the following operators.
Bookshelf Section > Integration Platform Technologies: Siebel Enterprise Application Integration > EAI UI Data Adapter Business Service > EAI UI Data Adapter Business Service Methods >QueryPage Method describes the supported operators that can be used in the seach Specification.
Operators: = | ~= | < | <= | > | >= | <> | LIKE | ~LIKE
SolutionTo implement the proposed solution, the following steps needs to be done:
1. In Siebel Client for the correspondent Business Object create a new PDQ that uses NOT LIKE operation.
2. The Web service client should pass the following element instead of the operator NOT LIKE.
PDQName = Name of the PDQ create in Siebel client.
The enhancement request CR#10565567 (Cannot use NOT LIKE operator in the searchspec field of UI Data Web service causes error) was created in order to address this requirement in future Siebel releases.
Oracle | Siebel Technical Support