Hi!
I need help.
How to pass list ID of Entities to SQL native query passed from external parameter (type Entity list)?
And second question. How to extend timeout of execution report? I have long queries in report and when executing long report sometime have connection loss.
How to pass list ID of Entities to SQL native query passed from the external parameter (type Entity list)?
You can use “Entity List” parameter alias in the SQL query. For example:
SELECT u.LOGIN as LOGIN FROM SEC_USER u WHERE u.id in ${entities}
where entities alias of the “Entity List” parameter. See also report in the attachment.
I have long queries in the report and when executing long report sometimes have connection loss.
You can run the report as a background task. The connection won’t be lost in this case. See [url=https://doc.cuba-platform.com/reporting-6.6/run_cancel.html]https://doc.cuba-platform.com/reporting-6.6/run_cancel.html[/url]