LIMIT rows returned from a single table

LIMIT rows returned from a single table

crush123crush123 Posts: 417Questions: 126Answers: 18

I have a ajax sourced datatable from a single table source.

The table has only a couple of thousand rows, so doesn't take long to load, but most of the older data is redundant, so i don't (usually) want to display it.

Whilst I can add a date filter to the ajax source, is there a way to LIMIT the number of rows returned ?

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,514Questions: 1Answers: 10,472 Site admin
    Answer ✓

    Not if you are using the Editor server-side class I'm afraid. You would need to apply a condition which it sounds like what you want rather than a limit anyway.

    Allan

This discussion has been closed.