Sebastian Krzewiński Community Champion

@TAGNAOUTI KhaoulaI'm glad that it work :) If you don't might please accept my answer so other users can see that this query is working ;)

What database do you have? This query works in PSQL. You can easily change it if it is needed in other database.

Hi @TAGNAOUTI Khaoula Query from article was not good. Try this one: select n.source_node_id, w.scheme, n.sink_node_id, w.workflow, w.issuetype from workflowschemeentity w join nodeassociation n on n.sink_node_id=w.scheme where n.source_node_id=<project_id> and n.sink_node_entity like 'WorkflowScheme' Now you need to know…

Hi @Pavel Chuyko My keyword was: "confluence unique page names". Articles about that (there is more than these): - https://community.atlassian.com/t5/Questions/Pages-with-same-name-in-space/qaq-p/443236 - https://community.atlassian.com/t5/Confluence-questions/Unique-page-titles-why/qaq-p/444090 -…

What query?

Hi @TAGNAOUTI Khaoula Mapping between project and workflow scheme (and other schemes) you can find in nodeassociation table. Then (knowing workflow scheme id used in project) you can find workflows assigned to issue types in this specific workflow scheme in workflowschemeentity table. Similar topic:…

Hi @Sean Marraffa Based on your question I see that you use Inight plugin. Did you try this: https://documentation.riada.io/display/ICV53/Insight+with+JIRA+REST-API ? Regards, Seba

"Basic" you mean Basic auth? What user do you use to authenticate with JIRA from Power Query?

Hi @Pavel Chuyko Unfotunately it's not possible to achieve this. Space in confluence it is not a tree of pages but collection of pages and every page must have unique name. There is a lot articles about that on community. Regards, Seba

Hi @Neeta Dubey Everythin what you need you can find in jiraissue table. Project id/name/key you will find in project table. Knowing both tables in database you can easily create proper select query to find issues. Regards, Seba

Hi Did you try to set anonymous or any logged in?

HI @Alex Hadden-Boyd You shouldn't be worried. JIRA wizard will help you. During this process you must map old status to new status and after that JIRA will do this. More info you can fin here:…

Hi @Felicia Nathhorst Malmgren How looks permissions to filter that you want to import? Regards, Seba

Hi @Burke Price Can you tell more about what you want to achieve? Regards, Seba

Now I have more motivation to achieve at least Level 4 :) Thanks for this article!

What is wrong?

Why do you think that automation didn't resolve this?

Hi @Marzi Goodarzian You added Jira Service Desk tag so I assume that you have JSD project. Please check automation in JSD (https://confluence.atlassian.com/servicedeskserver039/automating-your-service-desk-942846159.html) Regards, Seba

Hi @AbyzovaAV Please check this - https://library.adaptavist.com/entity/copy-field-value-from-linked-issue Regards, Seba

Hi @Brian Oconnell To list all issues in specific epic please use "Epic Link" = EPIC_KEY Regards, Seba

Hi @Руслан Хансуваров 1. As I remember if you have the same workflow on both issue types you can change issue type. But please check this because I might be wrong. Regards, Seba

Hi @Jennifer Jiang I see that you attached this information. My bad. It looks like you have your own setup in Configure Fields (link) Regards, Seba

Hi On what screen (create, edit, view) field is not visible? Regards, Seba

Hi @Руслан Хансуваров In JSD in one project you can add only one mailbox. I don't know if Atlassian want to change it. I'm also facing with this problem. As far I have two solutions: 1. Create mailbox that will be connected to JSD project. Then from your both mailboxes you must create rule that will be formward emails to…

Hi @Manuel Bastardo Castellano Only option what I see is get this information from issue description and then create user using script runner. Helpful links: - working with strings in groovy - https://www.tutorialspoint.com/groovy/groovy_strings.htm - create user using script runner -…

hi @饶青 As I understand what you want to achieve is that you want list all issue keys of linked issues. You must remember that you have 2 types of links: inward and outward. Also you must remember that JIRA build an array of linked issues in specific type. So if you have 3 linked issues (2 outward type, 1 inward type) you…

Hi @elvir.dzeladin This feature is available only for JSD comments. Regards, Seba

Hi @饶青 It is not possible to achieve what you described. I suggest move both projects to one project and achieve this scenario using Agile boards. Regards, Seba

Hi @Bethany Glismann Can you paste a screenshot of behaviours configuration? In my cases when behaviours didn't work the reason was in wrong place where I put script. Regards, Seba

Hi @Speed Jiang Go to Users and roles -> Edit defaults -> change project lead. Regards, Seba