Simplified workflow columns in sql

[Fredrik Ivansson Flinta]

How can I find workflows that are using Simplified Workflow in the sql database?

Have looked in AO_60DB71_ , workflowscheme and workflowschemeentity without any luck...

Thanks in advance. 

[Nic Brough -Adaptavist-]

You don't.

This is one of the reasons that you shouldn't be looking in the database - it does not hold the data you are thinking of in a way that is easily findable.

The workflow simplification data is calculated by the board, not stored in the database.

You need to use the UI or REST API for a board to see whether a board is using a simplified workflow.  (You can also look at the name of the workflow, but it is easy for admins to de-simplify a workflow without changing its name)

[Fredrik Ivansson Flinta]

But you cant get it thru endpoint board/{boardId}, board/{boardId}/project, board/{boardId}/configuration, board/{boardId}/properties, when on server/dc.

I have already tried that our before posting the original post.

According to the api documentation your statement might be true on cloud, but not on server.