Kinetic BAQ Whereclause condition for Grid to Loop the records and fetch values

Kinetic ERP
,
1

Hi Folks,

I have added the grid in the purchase order entry using kinetic application studio layer where it populates the data from the BAQ. I am passing the PONumber and TotalAmount as the parameter to BAQ and it works fine with the parameter. But I need to load the data as all records less than TotalAmount and only one record which is greater than TotalAmount.

Currently I have used the whereclause condition for the grid provider model as,
/*
UD100_ShortChar01 = ‘?{POHeader.BuyerID}’ AND UD100A_Number01 < ‘?{POHeader.TotalOrder}’
*/

Here I want to fetch only one record greater than the TotalOrder From UD table. I would appreciate your help.

Thanks in advance…!!