This guide shows you how to provide the resultset of an SQL to the user as Excel export by running a process.
Was developed by this issue: https://github.com/metasfresh/metasfresh/issues/4633.
In version 5.91 is a bug which prevents the class from being set automatically.
update ad_process set classname='de.metas.impexp.excel.process.ExportToExcelProcess' where ad_process_id= <your ad_process id>
select @C_Order_ID/-1@ as C_Order_ID , @AD_User_ID/-1@ as AD_User_ID , @C_BP_Group_ID/-1@ as C_BP_Group_ID , bp.* from C_BPartner bp
The context variables used in SQL will be resolved in following order:
where c_order_id = @C_Order_ID/-1@
where <column> in (@$WEBUI_ViewSelectedIds/0@)