Union in grid render sql

Suite and Optimus Suite 5
#1

I’d like to use union syntax.
(SELECT … FROM…) UNION (SELECT … FROM…) GROUP…ORDER…etc.
but
connector add own SELECT before my sql line
Looks like
SELECT (SELECT…

How to use UNION in connector or how to gather result from different data sources?

Lesnik

#2

Currently there is no way to use UNION in render_sql command of connector.