⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

how to load new data each time into datatable with a new query?

Started by , 04 March 2017 - 11:32 AM


JohnnyB
  • profile picture
  • Member

Posted 04 March 2017 - 11:32 AM

Hi everyone!

 

I just came across to this awesome / open source CRUD. There are things that I would like to achieve in the Data table.

 

Have a look in this example: http://www.grocerycrud.com/demo/orders_management

 

I would like to put 2 inputs on top of the table - OrderDate and Status.

 

When choose a date and status it should load the data table regarding to the query result. 

 

I have over 130,000 rows. takes a long time to load. The table should be loaded after choosing a date and status only.

 

So, my question is: How can I achieve this how to run the query and fill the datatable with the results based on chosen date and status?

 

Let's say I would like to list all the orders that has been ordered on 30/05/2005 - 00:00 with a status In Process.  I am not looking for filter feature. I am interested in filling the table with the aforementioned sql query result.

 

Thank you ver much in advance for your help.