[ Show result after typing. ]

[ Show result after typing. ]

alissonalisson Posts: 2Questions: 0Answers: 0
edited December 2011 in General
With the empty table, how do I show the results after typing?

After typing it generates the MySQL query result.

Replies

  • d_vineetd_vineet Posts: 19Questions: 0Answers: 0
    Can you be more specific in your question?
    Typing where & what? Using server-side function or what?

    Detailed Question with your code/illustration, etc. --> Better answers.

    -- Vineet
  • alissonalisson Posts: 2Questions: 0Answers: 0
    edited December 2011
    I have a table with 5000 records in MySQL

    For 5000 records list the delay.

    I then list only necessary after typing in the "Search"
  • allanallan Posts: 63,535Questions: 1Answers: 10,475 Site admin
    There isn't a build in option in DataTables to do this, but there are two options that I can see:

    1. Get your server to realise that there is no filter and thus return an empty result set
    2. Use fnServerData and before making an Ajax request, check to see if there is a filter applied or not. If there is, then do the Ajax result as normal. If there is no filter then just call the callback function with an empty data set.

    Allan
This discussion has been closed.