Ability to display work log comment or ticket comments in Confluence database field

Question

Hi there,

I am wondering if it is possible to display work log comments or ticket comments in a Confluence database. I realize it is a new feature so may not be possible. What I am looking to have is this comment (boxed in red), displayed in the database cell (full red box).

Box to display in DB:

Ste Wright · Answer

Hi @Alex Mann

You can see issue-based smart values here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/

Ste

Alex Mann_2upigz · Answer

Thanks Steve for the comments.

Isn't each row a Jira issue though? If yes, how would it know which comment to add?

I was hoping there would be a field where I could select the entire array of worklog comments.

Could you please help to point me to the documentation where I can see all the jira fields available? Where can I find the data structure details to know that comment exists with fields like "last" and "body" as you referenced here:

Ste Wright · Answer

Hi @Alex Mann

If the field is not available to select, I would assume it's not available. It's not something I've tried at this point though.

This page does detail how to select custom fields though...

Only standard Jira fields are shown. Custom fields can also be used by typing the text field name into the select field.

---

Isn't each row a Jira issue though? If yes, how would it know which comment to add?

An alternative might be to...

* Create a custom paragraph field in Jira - eg. Last Comment, Last Worklog Comment
* Populate it using Automation for Jira, when a comment is added or work is logged* You can use smart values such as...* Comment - {{triggerIssue.comment.last.body}}
* Worklog Comment - {{worklog.comment}}

* See if this field can be used in the database

Ste