Hi,
i've a issue to export my list in CSV format.
My list is pre-filtered through a pre-filter that takes a value via a placeholder.
The code in value field is:
I send {___data_ammortamento} through a form.
The code works fine, I visualize the list correctly, but if i try to export it to CSV I recive a message that inform me that there are 0 results...
If i try to set a fixed value to {___data_ammortamento} in the code (ex: 2016/08/26), export operation works fine.
It seems that, in the export operation, the placeholder is not considered.
Any help?
Thanks a lot
i've a issue to export my list in CSV format.
My list is pre-filtered through a pre-filter that takes a value via a placeholder.
The code in value field is:
Code:
$db = JFactory::getDBO();
$db->setQuery("select f.id_cespite_calcolo, f.nr_rata, f.id_calcolo
from (
SELECT id_cespite_calcolo, max(nr_rata) as ratamassima
FROM `qiwyk_cck_store_form_calcoli`
where data_ammortamento <= '{___data_ammortamento}'
group by id_cespite_calcolo
) as x inner join qiwyk_cck_store_form_calcoli as f on f.id_cespite_calcolo = x.id_cespite_calcolo and f.nr_rata = x.ratamassima
");
$db = $db->loadObjectList();
foreach ($db as $row)
{
$arr_id[$row->id_calcolo] = $row->id_calcolo;
}
$arr_id = implode(",",$arr_id);
return $arr_id;
I send {___data_ammortamento} through a form.
The code works fine, I visualize the list correctly, but if i try to export it to CSV I recive a message that inform me that there are 0 results...
If i try to set a fixed value to {___data_ammortamento} in the code (ex: 2016/08/26), export operation works fine.
It seems that, in the export operation, the placeholder is not considered.
Any help?
Thanks a lot