Pull request state

[Hasmik Hovhannisyan]

I'm trying to setup an automation to check the linked PR status and move the ticket back to the previous status if the PR is in "Draft" status. 

I've found some option in community but seems those are not working. 


I"m using smart value {{pullRequest.title}} and checking if that contains "Draft" and another option is I'm checking if {{pullRequest.state}} equals "Draft" and no success. Audit logs show that the issue didn't match the condition. 

Any ideas?

[Thomas B]

I wouldn't recommend manually manipulating the JIRA DB, as this could cause issues unless the query is provided by the Atlassian Team. Upon creating a new project, system creates a ID in dbo.project which is a foreign key to other tables such including project & board tables. 

Did you restart your instance after deleting a project? I've had this same issue in the past and the system needed a restart to resolve the issue. 

[Tom Lister]

Hi @[deleted]

The old project key will still exist in the jiradb.project_key table

It can be removed but I'm sure there are other tables check which I've forgotten

Hopefully someone else will chime in while i search the db.

[Alexey Matveev]

Hello,

There is no trash. What exactly is the error?