I'm building a rollup report that will collect Action Items from tables in a number of child pages into a single table at the parent. One of the columns is the Owners field. We use the @mention functionality to add the Conf users to that field so they will be notified when they are tagged.
Example (including the ' before @ in the example so I don't actually create @mentions - they're normal user-pill mentions in the actual data)
Row 1 Status: Done Owners: '@John Smith '@Davey Jones '@Fred Flintstone
Row 2 Status: In Progress Owners: '@John Smith '@Fred Flintstone
Row 3 Status: Done Owners: '@Davey Jones
Row 4 Status: Not Started Owners: '@John Smith '@Davey Jones
I'd like to be able to use the Pivot Table functionality to show each user in that field and the number of times they are mentioned, like this:
User Not Started In Progress Done
John Smith 1 1 1
Davey Jones 1 0 2
Fred Flintstone 0 1 1
The problem is I can't figure out how to disaggregate that list of users in the Owners field. I could potentially go through and insert a semicolon between each of the entries in the underlying child pages, but that seems kind of silly when Confluence knows that they are distinct values for display purposes. But I'm not able to identify the mechanism that Confluence uses to do that identification, so I don't know how to identify the delimiter that would separate the names.
Is there a way to break down that list using SQL or some other means in the Table Transformer?
