Forums
Lawson Landmark
Limit records extracted in a Landmark Query Node
Author
Messages
JimY
Veteran Member
Posts: 510
1/4/2016 5:06 PM
Is there a way to limit the number of records that a Landmark Query Node extracts? I am doing some testing and want to extract say the first 200. Thank you.
Tim Cochrane
Veteran Member
Posts: 154
1/28/2016 4:46 PM
JimY - assuming you're talking about within IPA...
What I've done before is add a counter and a branch, where one leg goes back into the query and the other exits when count = max records desired.
JimY
Veteran Member
Posts: 510
2/2/2016 2:23 PM
Thanks Tim.
LisaC
New Member
Posts: 2
2/13/2019 9:14 PM
Inside the query node you can set a variable called 'pages'. This is actually the number of records you want to pickup in one query. This so that you don't eat up your memory with all the records that are possible with one query. If you use this then you have to use a field inside your query return called 'hasNext', 'hasPrevious' to know if you have more records to pick up. My 'pages' is set to 30. In this particular query, if I have over 30 records, something is really wrong.