There is any database table in JIRA has the mapping information between workflow, Issue Status and project?
I checked the database but I didn't find a table with this association.
Could you please help me for this issue?
You'll need a hideous join between project, a load of tables with "scheme" in the name, some more tables with os_ as a prefix, a couple with workflow and then jiraissue.
Please, don't try to read the database, it's the worst possible way to get information from Jira.
Could you explain what you are trying to achieve, we can almost certainly give you a much better way to do it than SQL?
Thank you for your return.
In fact, hte user has closed same issues without informing the closing date, I want making a script to fill the closing date by the resolution date, in "post-function" of workflow.
To do this, I need first the "workflows" that correspond to the issues having the "closed status"
If you mean to get the associated workflow with a specific status it is easy to get this information from the issue status page
- Choose Admin > Issues
- Select Statuses to open the 'Statuses' page.
Then you can get the associated workflow with close status
It is going to be easier to do this in the UI than with torturous SQL.
The short version is "look at the project(s) configuration to see what workflows are in use"
The longer version:
Run a search that finds all the issues you are interested in and save it (probably something like "status = closed and resolution date is empty"
Add a dashboard gadget for "filter statistics" and tell it to look at your filter. Select "project" first to see what projects you need to look at, then maybe issue type to see what types are in use
For each project, look at the "workflow scheme", which tells you what workflow is being used by each issue type
It is a bit hard to navigate Jira's database because you have to take into account the schemas, which are the ones that really relate everything to the projects. I am not sure what you are trying to achieve some information is stored in weird tables.
In case this is of help, you can checkout Jira's tables relationsships here https://developer.atlassian.com/server/jira/platform/database-schema/
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