Hello Abu, when i try with "select_command" send me an error when i try to export to excel, is like if the framework adds the clause "HAVING ORDER BY 1 asc". next show you what i try:
what i define in select_command:
"select inm.id,nombre,nolotes, lotetipo, m2cons, valor_lista,precio_lista, valor_contado, enganchep,enganche, apartado, plazo_enga, plazo_saldo,pagos, tasa_int, vol_venta, meses, tam from inm,estudy where inm.id=estudy.client_id and substr(fecha,1,7)='3013-11' and tipo=2 group by inm.id"
error when try export to excel:
Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1 asc' at line 1 – select inm.id,nombre,nolotes, lotetipo, m2cons, valor_lista,precio_lista, valor_contado, enganchep,enganche, apartado, plazo_enga, plazo_saldo,pagos, tasa_int, vol_venta, meses, tam from inm,estudy where inm.id=estudy.client_id and substr(fecha,1,7)='3013-11' and tipo=2 group by inm.id HAVING ORDER BY 1 asc
by the way, if i remove the part "group by inm.id", works…