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; } } }

Querying dbo.jiraworkflows in MS SQL Server

Ben R

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.

Accepted answers

Nic Brough -Adaptavist-

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

All comments

Nic Brough -Adaptavist-

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

Ben R

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 R

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server