Okay
  Public Ticket #2743463
Limiting number of ROWs loaded in table
Closed

Comments

  • Gary Mattox started the conversation

    We absolutely LOVE this plugin...It works great, thanks so much..!

    Usage question:  Our tables look great but there are times when our data source (CSVs) contain more rows than we want to have visible.  For instance, our source CSVs may contain 1000 rows and we want to sort the data and show only the top 100 rows.  Is there a way to limit the number of rows displayed in wpDataTables rather than modifying the code that produces the CSVs?

    Thx,

    Gary

  • [deleted] replied

    Hi Gary

    Thank you for reaching out to us. 

    If the table is created as a link to an existing data source, this can't be done, because the plugin reads the source file, and displays it whole on front-end using JavaScript. 

    You could import the CSV file, and create a table like that, so then you would be able to use the SQL query, but I don't know if you need the data to be live and modified in the CSV file. If you do, importing the CSV will not help.