PG
I've created a query to present Roles in Process models within a Group/folder subtree, focusing on which Functions they interact with, and realized it was fairly easy to extract RASCI columns in the spreadsheet view to show exactly what they do, using the QUERY_IS_CONNECTED() function (with some digging to identify the API names of the connection types we've actually used in our filter). The query works fine as long as I stick to a single Group/folder. When I allow Groups/folders to recurse through a hierarchy, however, I get the Roles and Functions just fine, but the RASCI columns are missing from all but the top Group/folder models.
Is this a known error? We're still on version 10.0.21 of ARIS Enterprise.
Query definition (attached as EQI file):
Spreadsheet template:
Result for top folder models (as expected):
Result for nested folder (there should be a bunch of R's in the indicated column):
Unfortunately, no, it doesn't work. The query shows blank RASCI results when the models are in a subgroup, but everything's great when they are in the starting group.
However, though I haven't tested it extensively, it seems to work when I have two starting points: not just the root group, but also (any one of?) its subgroups. Seems like bug territory to me.
