Wonach suchst Du?
What are you looking for?

Provide the result of an SQL as process to the user

Overview

This guide shows you how to provide the resultset of an SQL to the user as Excel export by running a process.

Origin

Was developed by this issue: https://github.com/metasfresh/metasfresh/issues/4633.

In General

In version 5.91 is a bug which prevents the class from being set automatically.
Workaround: update ad_process set classname='de.metas.impexp.excel.process.ExportToExcelProcess' where ad_process_id= <your ad_process id>

The context variables used in SQL will be resolved in following order:

Sample

image

image

image

image

image

image

image


View source file on GitHub.com