Querying dbo.jiraworkflows in MS SQL Server

[Ben Robbins]

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

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

[Nic Brough -Adaptavist- · Accepted solution]

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

[Ben Robbins]

Forgot about this post....

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

[Nic Brough -Adaptavist-]

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

[Ben Robbins]

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.