PG

I'm experimenting with a query to ensure designers have filled in mandatory model attributes. The idea is to point the query at a group, get a list of models within that group or its subgroups, and identify which ones have left any mandatory attribute blank. So, I designed a simple hierarchical query on group and model

image

and defined a reasonably straightforward spreadsheet template on Models and their attributes

image

with Model defined as =QUERY_ITEM("6f0ba47c-97f2-4e2a-be94-b5628c79dc96";TRUE;TRUE) and expected to get a vertical list of models and their attributes. Instead, I get a separate list of repeated Model+attributes columns, apparently one for each level of nesting of Groups (Model (1) next, then Model (2)... and so on depending on nesting depth).

image

I assume something about the Group hierarchy doesn't play nice with the spreadsheet template, but how? When would I like to repeat objects horizontally, and is there any way of avoiding it?

 

File attachments
by Pontus Gagge Author
Posted on Tue, 01/07/2020 - 09:00

In reply to by m3b

I wonder what use case drives that strange design: it rather undercuts a lot of uses queries would otherwise have. Thanks. 

0
by Peter Lukac
Posted on Fri, 01/31/2020 - 12:37

In the upcomming April release it is going to be changed. If you will not put the recursive node into the template sheet, then the results are going to be placed horizontally. E.g. in your case as you did not put the group node to the sheet - all the models will be placed into one column, not multiple ones.

 

 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
There is still some space in this week's top 5 for you - this is your chance to become one of our top members of this week. Register now to start collecting points!
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock