Use a UNION of two tables in a view datasource

Technologies > User Interface Add-Ins > Parts for Reports > Report with Two Tables in One Datasource

Use a UNION of two databases in a view datasource. Grid Report with Custom SQL Query and data from multiple tables in a single data source

<dataSource id="reportGridSqlUnion_ds">
<!-- Custom SQL query is used as a data source for all displayed grid records. It can include calculated fields. -->
<sql dialect="generic">
SELECT 'Lease' AS src_table, ls_id AS id_field_1, '' AS id_field_2, date_start, date_end
FROM ls WHERE date_start &lt; ${sql.date('2009-01-01')} AND date_end &gt; ${sql.date('2009-01-01')}
UNION
SELECT 'Option' AS src_table, ls_id AS id_field_1, op_id AS id_field_2, date_option AS date_start, date_review AS date_end
FROM op WHERE date_option &lt; ${sql.date('2009-01-01')} OR date_review &lt; ${sql.date('2009-01-01')}
</sql>
<table name="ls" role="main"/>

<!-- All database fields used in the SELECT caluse must be declared here. -->
<field table="ls" name="src_table" dataType="text"/>
<field table="ls" name="id_field_1" dataType="text"/>
<field table="ls" name="id_field_2" dataType="text"/>
<field table="ls" name="date_start" dataType="date"/>
<field table="ls" name="date_end" dataType="date"/>
</dataSource>

View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/grid/ab-ex-report-grid-sql-union.axvw