jcc
Member
I am running J! 2.5.7 & Fabrik 3.0.6.3 + the 2-Oct github on the public site and 29-Oct github on development with the same results.
I have 3 lists that are filtered. I cannot export any of them - I get the:
"Loading
0 / records.
saving to"
and then the popup with:
"No records available for CSV export"
that others have noted. Using my chisel-and-tablet debugging (still haven't got Eclipse configured on my system) I was able to get to the getTotalRecords call from components\com_fabrik\views\list\view.csv.php which seems to be generating a query with a where clause like:
This will obviously return 0.
Somewhere my supplied query (clipped from Firebug Post Source) is getting trounced.
Any ideas?
I have 3 lists that are filtered. I cannot export any of them - I get the:
"Loading
0 / records.
saving to"
and then the popup with:
"No records available for CSV export"
that others have noted. Using my chisel-and-tablet debugging (still haven't got Eclipse configured on my system) I was able to get to the getTotalRecords call from components\com_fabrik\views\list\view.csv.php which seems to be generating a query with a where clause like:
Code:
WHERE 1 = -1
Somewhere my supplied query (clipped from Firebug Post Source) is getting trounced.
Code:
excel=0&inctabledata=1&incraw=0&inccalcs=0&incfilters=1&fields[mailing_labels___account_name]=1&fields[mailing_labels___address_line1]=1&fields[mailing_labels___address_line2]=1&fields[mailing_labels___address_line3]=1&fields[mailing_labels___address_line4]=1&fields[mailing_labels___zip_code]=1&fabrik___filter
[list_63_com_fabrik_63][value][0]=&fabrik___filter
[list_63_com_fabrik_63][condition][0]=contains&fabrik___filter
[list_63_com_fabrik_63][join][0]=AND&fabrik___filter
[list_63_com_fabrik_63][key][0]=%60mailing_labels%60.%60renew_date%60&fabrik___filter
[list_63_com_fabrik_63][search_type][0]=normal&fabrik___filter
[list_63_com_fabrik_63][match][0]=&fabrik___filter
[list_63_com_fabrik_63][full_words_only][0]=0&fabrik___filter
[list_63_com_fabrik_63][eval][0]=0&fabrik___filter
[list_63_com_fabrik_63][grouped_to_previous][0]=0&fabrik___filter
[list_63_com_fabrik_63][hidden][0]=0&fabrik___filter
[list_63_com_fabrik_63][elementid][0]=1194&start=0&option=com_fabrik&view=list&format=csv&Itemid=0&listid=63&listref=63