Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

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

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.