How to show needed records in DB multi record?

Hi and thanks for great component!

Can you please explain how to show in DB multi record only records that were created on choosed date?

Thank you.

Hi tempus,

In CFv4 you can add a MySQL WHERE statement in the DB Multi-Record Loader action. Provided that your selected date is in a format that MySQL can read you should be able to use it directly.

Bob

Ok, but is it possible to set the date by datepicker in form and provide the result in multirecord loader?

I understand that I need to use the WHERE statement in advanced options tab. But how to load date from datepicker to it?

Hi tempus,

In CFv4 you can use code like this to add the value from any input

<?php echo $form->data['input_name']; ?>

Note that you must take care to get the MySQL syntax correct including any necessary quotes around string values.

Bob