nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to identify all spaces using a Space Workflow with Comala Document Management

Charlie Misonne

We are using Comala Document Management on Confluence server and I'd like an overview of all spaces using a Space Workflow (= workflow not defined as global workflow).

I tried creating a SQL query but I don't know where the reference space - workflow is kept.

Accepted answers

Pablo Gallego _Appfire_

Hi Charlie,

The following SQL query will display only the spaces that have enabled workflows declared at space level (ignoring linked global workflows). If you would like to include the spaces that have workflows declared but that are disabled, then removed the last condition of the "WHERE".

SELECT 
DISTINCT S.SPACEKEY,
S.SPACENAME
FROM
BANDANA as B,
SPACES as S
WHERE
B.BANDANAKEY LIKE '%com.comalatech.workflow.production.template%' 
AND B.BANDANACONTEXT = S.SPACEKEY 
AND B.BANDANAVALUE NOT LIKE '%disabled=true%';

If you have future questions about Comala Document Management you can contact our friendly support team at https://support.comalatech.com any time.

Regards,

Pablo Gallego

Software Engineer at Comalatech

All comments

Pablo Gallego _Appfire_

Hi Charlie,

SELECT 
DISTINCT S.SPACEKEY,
S.SPACENAME
FROM
BANDANA as B,
SPACES as S
WHERE
B.BANDANAKEY LIKE '%com.comalatech.workflow.production.template%' 
AND B.BANDANACONTEXT = S.SPACEKEY 
AND B.BANDANAVALUE NOT LIKE '%disabled=true%';