Enable union and union all capabilities in Report Builder

[gdeforest]

There is already an ability to create a compound query by manually editing QML files and you can assign a type to these compound queries of union or union all.  Howerver, if any of the sub queries being unioned return no data the report will fail.  After speaking to a support analyst it seems the compound query types union and union all are not supported (though they are available).

This could realistically be a resolved in a phased approach

1) Enable/fix the union and union all compound query types that seem to already exist so they funciton properly if any of the sub queries return no data.  The user will need to manually build the QML.

2) Introduce the compound query capabilities into the Report Manager itself.

Being able to create compound queries will be a huge benefit for querying/displaying system data.

[Marco_Tosin]

Gary I think you could join this group http://communities.ptc.com/groups/reporting?view=members

and also vote this two ideas http://communities.ptc.com/ideas/4634 and http://communities.ptc.com/ideas/4659.

And maybe take a look at this document http://communities.ptc.com/docs/DOC-6348 if you haven't seen yet.

[JoachimLoos]

This seems like a relatively easy to implement feature and would help a bunch in many situations.

Gary DeForest‌,

would you have a sample QML for a compund query?

[Hugo-KTM]

Is there a DTD or XML Schema available for QML?