Does the adapter support the 'ORDER BY' option while querying Siebel ( E.g., -- select * from SR where status='open' ORDER BY created date)?

Does the adapter support the 'ORDER BY' option while querying Siebel ( E.g., -- select * from SR where status='open' ORDER BY created date)?

book

Article ID: KB0085622

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Siebel -
Not Applicable -

Description

Resolution:
No. Adapter does not support specfying the sort order in the query. The Sort order can be specified for the Business Component in Siebel itself. Please refer to section 'Sort  Specification Property' in Siebel Bookshelf for details on how to specify the Sort

Order for a Business Component.

Issue/Introduction

Does the adapter support the 'ORDER BY' option while querying Siebel ( E.g., -- select * from SR where status='open' ORDER BY created date)?