It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Querying dbo.jiraworkflows in MS SQL Server

Short question: Is it possible to query the xml string held in the DESCRIPTOR field on the dbo.jiraworkflows table?

We're trying to audit user group conditions we have set on certain transitions in workflows.

1 answer

1 accepted

0 votes
Answer accepted

You can, but it's raw XML so you'll have to parse it after extracting it.

Forgot about this post....

Can you give any advice on parsing this in SQL Server?

SQL Server does not have xml parsing functions that I know of.  It's a database, not an XML editor!

I'd copy the xml and open it in something that is good at reading XML

Yes, I was afraid you were going to say that. We were hoping to build an SSRS report on a query that extracted conditions from workflows but doesn't seem like that's going to be possible.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you