Updating Confluence Page Status based on Comala Status

[Sarah Ni Riain]

Hi all, 

My situation is this: 

I am trying to manage our FAQs using the Confluence Database feature to list the different answers that should appear in different locations (linking to the Page that contains the answer text and using labels to filter for the different locations)

We are using a Comala workflow to manage approvals for the FAQs and I would like to show this as a column in the Confluence Database. I can see that there is no current way to do this, so I am wondering if there is a way to automatically map the Comala status from the workflow as the Confluence page status? I could then use the Page status to reflect the Comala status in the database field.

If anyone has managed a different workaround or has a potential solution to my dilemma I'm open to anything!

Confluence Cloud is the product we are using.

Cheers,

Sarah

[Humashankar VJ]

Mapping the status of a Comala workflow is directly unavailable and this is confirmed when I worked on a similar effort, when i reached Comala they said they didn't support integration of Comala Document Management with user macros.  They did however suggest I look at the following:

Using a CQL filter in the document-state-report macro to report on grandchildren of a page

I found that I could use the document-state-report macro and use a CQL filter of

    ancestor=pageid OR id=pageid

to include the root (index) page as well as descendant pages.

However there were a few issues still remaining:

1. The page order is not the hierarchical one, although various columns can be sorted.
2. When I included a last final version column it was only populated if the page had been approved at some time, otherwise the entry was blank. When populated it showed the last approved version, not the current version. They have a ticket to fix this.
3. The biggest issue was when I used Space Tools > Content Tools  > Export to produce a single PDF of the whole page tree from the root downwards. In this case the table rendered on-screen was not reproduced in the PDF file. Instead the placeholder text
   
       Comala Document Management add-on...
   
   appeared in its place.
   
   I could do Print in the browser and select Microsoft Print to PDF as the printer, as that does render the Comala macro correctly, Then I could use Space Tools to export the descendant pages as a second PDF file and then stitch the two together. However this is a bit of a hassle when the aim was to easily and quickly produce a single PDF I could archive.

Happy to help any further !!

Thank you very much and have a fantastic day!
Warm regards