Populate datatables through drop down selection

jmschaap

Hi,

I'm kinda new to Datatables and get the gist of some of the basic functions, but now I'm trying to do the following:

I have one dropdown menu with customers and one with accounts. After selecting a customer from the first dropdown menu, jQuery retrieves data from an external source and populates the second dropdown with the selected customer's accounts. After selecting an account, I want to populate the Datatables with the correct usage data, without the page completely refreshing. So I'm hoping to get this done with jQuery again.

The external server I'm getting the data from has a limit on how much records it can send on one request. I'm using PHP CURL command to retrieve the data from the server, which returns data in JSON format with a maximum of 150 lines. Some accounts have a few thousand records but since the server only returns 150 records each time, I can't use the standard pagination from Datatables. The API does allow me to retrieve the next 150 records from the same account by using query parameters, so I'm able to create some manual pagination (unless Datatables supports this somehow as well )

What should I do to get this working?

Sorry if this makes no sence

Greetings,
Maikel

jmschaap

Never mind. Already fixed it

allan

Thanks for posting back. Good to hear you've got it fixed!

Allan