Using Group By and Order by Clause in Siebel adapter

, ,
1

How can I achieve the following by using the sieble adapter in wM?

SELECT column1, column2, column3
FROM table1
WHERE column4 = ‘xxxx’
GROUP BY column1, column2, column3
ORDER BY column3 DESC

I created a siebel adapter service for querying on the table1.

Using the “Search Tab”, I prepared where clause -->column4 = ‘xxxx’.

But how can I prepare “Group By” and “Order by” clauses?

Also I want only the first row in the result set. How can I do that?

2

I don’t think you can. The Siebel adapter isn’t SQL based, AFAIK. The things you can do with the adapter are all represented on the tabs presented in the service definition in Developer.