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.

[Pablo Gallego _Appfire_ · Accepted solution]

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 

[Charlie Misonne]

This is great. Thank you for the quik reply!

[Pablo Gallego _Appfire_]

You are welcome :) 

[Divya Krishnamoorthy]

if i need global workflow which spaces are using .please provide me sql