oData for randomly reading 500 POs in one shot?

[Former Member]

Hello,

We are listing out around 1000 order numbers on UI with checkbox ability, well. now user want to select RANDOMLY around 500 orders out of displayed 1000 numbers and want to read its header data, pl. let me know how can I build oData service? I mean, how I can build a query bcz I guess specifying user selected all 500 orders numbers on the query is not a good idea?

Thank you

[CarlosRoggan]

Hi,
what about defining a FunctionImport?
e.g. getRandom(500)

So the Backend does calculation based on existing 1000 entries
On UI, there can be a Button "RandomSelect" and it triggers that FunctionImport and also does the selection of the result
Cheers,
Carlos

[Former Member]

Thank you Carlos. Pl. let me know

1) On UI, there can be a Button "RandomSelect"

After user pressing the Button "RandomSelect" how can I send user randomly selected 500 PO numbers to oData, I mean, how my "getRandom(500)" FunctionImport knows about the user selected 500 PO numbers, do I need to specify all those 500 PO numbers on the service URI?

2) So the Backend does calculation based on existing 1000 entries

Why backend need to perform any kind of calculations here, my goal is just pull data, its just need to read EKKO table's few fields recs for those 500 POs