How to use Siebel Query Operators to query Siebel IO data in certain Date range or Number range

How to use Siebel Query Operators to query Siebel IO data in certain Date range or Number range

book

Article ID: KB0074640

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix Adapter for Siebel 6.1.0

Description

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. 

Issue/Introduction

How to use Siebel Query Operators to query Siebel IO data in certain Date range or Number range

Resolution

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'"

==============

Attachments

How to use Siebel Query Operators to query Siebel IO data in certain Date range or Number range get_app
How to use Siebel Query Operators to query Siebel IO data in certain Date range or Number range get_app