Select adapter service - Maxrowcount

[Sandeep_Deepala (wm developer)]

Hi folks,

Is there a way to pass maxrowcount dynamically during run time to a select adapter service, without hardcoding to a specific value in select adapter service?

[Venkata_Kasi_Viswanath_Mugada1 (Kasi Mugada)]

I don’t think it’s possible with “Maximum Row”. However, you can use Dynamic SQL adapter, wherein you can use the rownum or limit operators in the query, according to your database type and pass its value as an input variable to the adapter service.

Examples -

• sql - How do I limit the number of rows returned by an Oracle query after ordering? - Stack Overflow
• Use Oracle FETCH to Limit Rows Returned by a Query

KM

[Sandeep_Deepala (wm developer)]

@Venkata_Kasi_Viswanath_Mugada1

rownum

rownum passing it in adapter as a input parameter worked