Save datepicker range

m75sa

Hi, i'm using datatable with date range filter by using datepicker.
When i set
stateSave: true

it saves all values except the range set into the input datepicker field.
Any help on this?

Have a look here:
http://live.datatables.net/kajabeli/2/edit

allan

Thanks for the link. I don't see anything there that is saving the date values into the state storage or that is writing them back when the state is loaded.

You've used stateSaveParams and stateLoadParams which is correct, but your functions need to integrate with your custom date inputs as well.

Allan

m75sa

thanks allan, can you help me how to integrate?

allan

Writing a custom example is something that would fall under our pro support packages.

However, writing a value to the state is something just like: data.start_date = $('#start_date').val();. Restoring it is similar.

Allan

m75sa

thanks Allan, unfortunally i cannot manage it... for this reason I wrote on this forum in order to "learn" from a workly example. But i f this is related to a payment plan subscription I don't want to insist.

kthorngren

I updated your example with what Allan suggested:
http://live.datatables.net/kajabeli/12/edit

I assume the button below is used for searching the date range and that you have a function for this. I created a click event for the button which executes draw(). This saves the state.

Kevin

m75sa

Thanks a lot @kthorngren, now i can learn from your example! Very appreciated

m75sa

@kthorngren sorry, thanks to your example now i'm able to save the date picker value also if i reload the page... but i would like to pass via ajax the saved values to the post.
So in addition to your code, i have:

ajax : {
url:"file.php",
type:"POST",
data:{
start_date:start_date, end_date:end_date
}
}

where start_date and end_date are setted by this block:

$('#search').click(function(){
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
});

What i'm not able to do is to pass the saved date-picker to the post in order to have the correspondent result when the user reload the page...

hope you understood what i mean and thanks again !

kthorngren

Assuming you are using ajax you would use ajax.data as a function. See the examples in the docs. Also see this running example.

Kevin

m75sa

thanks @kthorngren, all clear now!

m75sa

@kthorngren again me...
now happens that the datepicker input has, as default value, the state save. And this is correct. But if i want that every time I open the page the default status of the date-picker value is the current date (and not the save state)? So only the first time... then when i change the date-picker value of course the save.state should work...

I set on the input value the code like:

<input name="start_date" type="date" class="form-control" id="start_date" value="<? echo date("Y-m-d") ?>" />

so when i open the page, and there is no state.save, i can see the current date... correct, but when i click the picker date the state.save starts working so the next time I will re-open the page I will NOT see the current date anymore...
Any ideas how to set the behaviour?
thanks a lot

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin