cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Enable union and union all capabilities in Report Builder

Enable union and union all capabilities in Report Builder

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.

5 Comments
Marco_Tosin
Tanzanite

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
Participant

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
Granite

Is there a DTD or XML Schema available for QML?

PTCModerator
Emeritus
Status changed to: Under Consideration
 
JeffZemsky
Peridot
Status changed to: Acknowledged