Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Charlie Misonne
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 12, 2020

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.

2 answers

1 accepted

4 votes
Answer accepted
Pablo Gallego _Appfire_ November 12, 2020

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 12, 2020

This is great. Thank you for the quik reply!

Like Pablo Gallego _Appfire_ likes this
Pablo Gallego _Appfire_ November 12, 2020

You are welcome :) 

0 votes
Divya Krishnamoorthy February 13, 2024

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

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events