How to display the (comala) publication date of a page using a macro?

Question

We use comala workflows to publish confluence pages. I wrote a little macro to display the publication date.  However, depending on the final page status "Published" I want to derive the actual published date. I do NOT want something like the last modification date as done and working here:

$action.dateFormatter.formatGivenString($paramMYDATE,$content.getLastModificationDate())

The problem is, I do not know how to fetch the actual publication date, as the modification date is not what I am looking for:

$content.getLastModificationDate()

In the comala workflow definition, I am able to set custom metadata like this.

@{set-metadata:approveddate}@datetime@{set-metadata}

And I can use the comala "Get-Metadata" Plugin to fetch the actual value. But I need to fetch the metadata from a common confluence user-macro.

I want something like:

$content.getApprovedDate()

(My example does not work...)

Is there any easy method to fix my issue? If not, is there any easy way to display the available methods?

James Conway_4h3kp2 · Answer

Hi @Marlene Pirker

I answered your question here:  https://community.atlassian.com/t5/Confluence-questions/Change-Time-Zone-in-Comala-Workflow/qaq-p/1693601

All the best

James
Senior Product Manager

Marlene Pirker · Answer

Hi! This really helped me. But I have a problem now: the time zone is the wrong one. Do you know how to change it?

Andreas Schwab_xy8kn6 · Answer

Thanks a lot Jorge!

I think you showed a comala worflow definition. However, I really want to fetch the set metadata from a confluence user-macro.

E.g. the

{set-metadata:approveddate}@datetime@{set-metadata}

Reason for that is that the user-macro currently used is already in place for many pages. I can fetch that easily using the comala "Get Metadata" macro. But this is not what I need. I'll edit my original post for clarification!