Problem using csv

[plagonell]

Hello, when I use the csv component it does not download the file, the code in sql

SELECT 'dynamic' AS component,
        sqlpage.run_sql('shell.sql')
        AS properties;
select 
    'csv'              as component,
    'Descarga'         as title,
    'beneficiarios_ok' as filename,
    'file-download'    as icon,
    'green'            as color,
    ';'                as separator,
    TRUE               as bom;

select 
    'table' as component,
    TRUE    as sort,
    TRUE    as search,
    'Nada que mostrar, no hay jornada abierta en este momento.' as empty_description;

SELECT
	"vBeneficiario_ticket".ente as ente, 
	"vBeneficiario_ticket".cedula as cedula , 
	"vBeneficiario_ticket".nombres_apellidos as "Nombres y Apellidos", 
	"vBeneficiario_ticket".unidad_adscripcion as "Unidad de Adscripcion", 
	"vBeneficiario_ticket".estatus_autorizado as "Autorizado", 
	"vBeneficiario_ticket".fecha_entrega || ' ' || "vBeneficiario_ticket".hora_entrega || ' ' || "vBeneficiario_ticket".meridiano as "Entregado",
	"vBeneficiario_ticket".ticket as "Ticket"
FROM
	"vBeneficiario_ticket";

Ouput is empty

Thanks ..
It is a great product...

[lovasoa]

Hello !
The documentation for the csv component is here: https://sql.datapage.app/component.sql?component=csv
It takes the contents of the csv as row-level parameters. In your example above, you don't pass any row-level parameter, so you get an empty CSV. If you want a csv with the same contents as the table below, you can put the same same query after the declaring the csv component top-level parameters:

select 
    'csv'              as component,
    'Descarga'         as title,
    'beneficiarios_ok' as filename,
    'file-download'    as icon,
    'green'            as color,
    ';'                as separator,
    TRUE               as bom;

SELECT
	"vBeneficiario_ticket".ente as ente, 
	"vBeneficiario_ticket".cedula as cedula , 
	"vBeneficiario_ticket".nombres_apellidos as "Nombres y Apellidos", 
	"vBeneficiario_ticket".unidad_adscripcion as "Unidad de Adscripcion", 
	"vBeneficiario_ticket".estatus_autorizado as "Autorizado", 
	"vBeneficiario_ticket".fecha_entrega || ' ' || "vBeneficiario_ticket".hora_entrega || ' ' || "vBeneficiario_ticket".meridiano as "Entregado",
	"vBeneficiario_ticket".ticket as "Ticket"
FROM
	"vBeneficiario_ticket";

[plagonell]

Thanks a lot, I repeated the table select for the csv component and it worked like a charm