Notes Report: Does anyone know a way to group updates/comments/notes by thread (parent note)? Or show all comments as a discussion in the Notes report.
In the example below I would like to show the reply (thank you) under the parent (per Slack with ...).
Solved! Go to Solution.
Views
Replies
Total Likes
Thanks to Dustin on our team for figuring it out. Legend! Use the following Text Mode in grouping where X is whatever level you are grouping for:
group.X.valueformat=HTML group.X.name=Parent Note group.X.valuefield=parentNote:noteText
Views
Replies
Total Likes
I think you'll find some useful information in this post https://experienceleaguecommunities.adobe.com/t5/workfront-questions/report-on-tagged-updates/m-p/48...
(caution and cc to @jon_chen -- the responses are not formatted for code)
Views
Replies
Total Likes
Hey @skyehansen Thanks for the callout. I do not think code sample formatting was retroactively applied for our Community migration. However, we do support code sampling in the text editor. Please see the image below for reference on adding code into your posts moving forward.
Views
Replies
Total Likes
thanks Jon. I don't think there was any automatic formatting applied to our old posts the last time we transitioned to One either, so it's not unexpected.
However -- in the past, for the more valuable posts (such as the one I linked to), someone on the customer experience team had the ability to go in and reformat old posts to add the formatting. If I get to suggest things (
Views
Replies
Total Likes
Hey @skyehansen Thanks for the feedback. I went into the post you referenced and reformatted any code snippet I could find into a code sample. Hoping this will allow users to quickly find and copy-paste the text code most relevant to their use case. Please take a look and let me know if I missed any!
Views
Replies
Total Likes
Thanks, that's where I got the code for the "tagged" column (as a bonus) but I did not find what I was looking for. I tried the code below but this did not group by parent note as I hoped. Did I miss something?
group.0.descriptionkey=source group.0.namekey=source group.0.valuefield=sourceName group.0.valueformat=HTML textmode=true
Views
Replies
Total Likes
I think as the original poster mentioned, this kind of code would allow you to group by the object that the note was placed on (e.g. updates grouped by project, task, issue or document name). Melinda then mentioned maybe using a valueexpression to group using the source object and the last character or two of the thread ID (as well as ordering by date) in order to capture multiple threads on the same object.
My feeling is that if it's too hard to noodle out a valueexpression, you should just go with grouping by source object followed by grouping by thread ID (and arrange the notes in date order).
Views
Replies
Total Likes
I see. So, the threadID is not available from the drop down in the grouping section so you have to add it in text mode:
group.0.displayname=Thread group.0.linkedname=direct group.0.namekey=threadID group.0.valuefield=threadID group.0.valueformat=string textmode=true
Found here.
Is there a way to change ID to text like with other objects? threadID to thread:name does not seem to work in this case.
Views
Replies
Total Likes
I highly doubt that threads are named. For example, there's no subject field available on updates, so no way to "name" a thread.
Views
Replies
Total Likes
Hey @skyehansen - I'm reading back on that original thread and it looks like it has the solution I'm looking for (to show the thread as part of the note report) but I can't seem to see how it's all put together with all the recommendations.
Do you have an example of the report you wound up with?
Views
Replies
Total Likes
did Matt McC's solution below work for you? (parent note?)
Views
Replies
Total Likes
Thanks to Dustin on our team for figuring it out. Legend! Use the following Text Mode in grouping where X is whatever level you are grouping for:
group.X.valueformat=HTML group.X.name=Parent Note group.X.valuefield=parentNote:noteText
Views
Replies
Total Likes