I'm adding more than 1,000 lines to a sublist of t...
# ask-stanley-ai
a
I'm adding more than 1,000 lines to a sublist of type "LIST" in my suitelet script. The sublist is created by the suitelet and so is the form the sublist is part of. However, when the page loads, it only shows the first 1,000 lines. How can I get it to show all the lines? Would it have the same limitation if I used a different sublist type?
c
AI generated answer (using internal Slack threads):
The maximum number of lines that can be displayed on a sublist in a Suitelet is 1,000. This is a limitation set by NetSuite and it applies to all sublist types, including "LIST". If you try to add more than 1,000 lines to the sublist, only the first 1,000 lines will be displayed when the page loads. If you need to display more than 1,000 lines, you will need to implement pagination in your Suitelet. This can be done by storing the data in the session object and then retrieving it in chunks of 1,000 lines or less. In terms of sublist types, changing the sublist type from "STATICLIST" to "LIST" can increase the number of results displayed. However, this will not bypass the 1,000 line limit. As for setting sublist values via a ClientScript, make sure that the sublist is in editable mode. You can do this by following the instructions in the NetSuite Help Center article on serverWidget.SublistType. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.866333
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.861816406
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.856872618
Please provide your feedback on this answer.