Products | Versions |
---|---|
TIBCO ActiveMatrix Adapter for Siebel | 6.1.0 |
Some customers have requirement to query data in certain Date range or Number range by using Siebel Adapter, for example, query all records generated between Oct 1st and Oct 10th.
By using "searchspec" fetched field for IO, we can query Siebel IO data in certain Date range or Number range. This "searchspec" should be present with corresponding Integration Object for example, Account, Contact, etc has this field.
Below are some test cases for customer’s reference, customer can also refer to the screenshots for more information.
=============
SearchSpec="[Name] LIKE '3*'"
SearchSpec="[Main Phone Number] LIKE '5*'"
SearchSpec="[Main Phone Number] <= '5381630190'"
SearchSpec="[Main Phone Number] <= '5381630190' AND [Main Phone Number] >= '5381630185' "
SearchSpec="[Currency Code] = 'VEF'"
SearchSpec="[Created]>='08/05/2020 08:18:00' AND [Created]<'08/10/2020 08:18:00'"
So expected format is - "[Field_Name] Operator 'VALUE'"
==============