Prev
Next
Forums Infor / Lawson Platforms Lawson Landmark

Limit records extracted in a Landmark Query Node

 3 Replies
 0 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
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 Send Private Message
Posts: 154
Veteran Member
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.
Tim Cochrane - Principal LM/IPA Consultant
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
2/2/2016 2:23 PM
Thanks Tim.
LisaC
New Member Send Private Message
Posts: 2
New Member
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.
Lisa C