More than 100 rows in data publication

  • Resolved kebhin

    (@kebhin)


    2 years ago

    Hi

    I have a rather large table (20,000+ rows) and using the custom search builder to restrict the view by a date column – in fact I naturally need the data for a given quarter (e.g. Jul-Sep). However this still gives ~ 200 rows. I want all of them displayed so that I can use Excel button to export. However the maximum rows to display in the dropdown is 100.
    I looked in settings and couldn’t find anywhere to override that

    Can you help?
    Thanks
    Kebhin

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @kebhin,

    In Data Publisher, under Advanced Settings of your table, please add the following JSON:

    {
  "lengthMenu": [ 10, 20, 30, 50, 100, 200 ]
}

    You can further customize the above. Please refer to this page for more information.

    Hope that helps! Let us know if you have other questions. ??

    • This reply was modified 2 years ago by Kim L.
    Thread Starter kebhin

    (@kebhin)

    Thanks Kim, that does the job perfectly

    Plugin Contributor Kim L

    (@kimmyx)

    Great! ??

    I’ll mark the thread as resolved now.

    Feel free to create a new one if you have new questions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘More than 100 rows in data publication’ is closed to new replies.